Inconsistency result at ODT vs ODS report generation

[bromoapp]

I create 2 reports for the same data, one as ODS and 2nd as ODT.
My FODS template is like below

And my FODT template is like below

Both totally has the same logic, the same data to access.
But the result of FODT is correct (all data in the db are shown) as below:

While the result of FODS is in-correct (not all data in db are shown) as below:

Are there something that I missed? why FODT can renders all data while FODT not able to renders all data (green circled) ?

I did search topic on ODS not showing data.. I did found → here, but the solution link given my a guy name @mono has broken

Any advice would be appreciated

Regards
Bromo

[ced (Cédric Krier)]

Spreadsheet are typed format, so you can only display supported types (and Model instances are not supported).

[bromoapp]

Ah.. that explains expression: format_date(o.opportunity.start_date) .. okay thank you @ced .. thank you very much

Bromo