>Hi!
>
>>>I have created ods files using info-zip zip exe and windows send to compressed folder (*.zip)
>>>They open in Excel and LibeOffice without issues.
>>>So there is no such constraint. Where is such constraint specified ?
>>
>>Point 17.4 of the OASIS Open Document Format.
>
>I changed ExcelListner to create ods files.
>OpenOffice shows only one page, Excel throws file corrupted error and doesnt open.
>
>How to fix this, maybe some page setting is missing ?
>I posted it also in
>http://stackoverflow.com/questions/40489288/how-to-create-ods-file-containing-many-rows
>
>and this contains sample file also.

Can you do an incremental test on the report, that is, create a report with 1 record and see how LibreOffice accepts that, then 2 records, and check again, and so on until you break LO parser. Then, inspect the XML produced in the last run and confront it with the previous one...