SinglePageSheets export excel to pdf has lost the data after row number 1022

Convert to pdf lost the data when singlepagesheet filter applied.

Commnad to generate pdf - soffice.com --headless --convert-to “pdf:impress_pdf_Export:{“SinglePageSheets”:{“type”:“boolean”,“value”:“true”}}” inputfilepath --outdir outputpath

You export a spreadsheet? please note that impress_pdf_Export is wrong here, even though it’s not the problem that causes your trouble.

A sample spreadsheet would help others see and try to help this.

SmallValidFile.xls (611 KB)

Please find above attached file

Sorry to bump this older topic but just doing some research into SinglePageSheets & battling similar issues - rather than make a new post just thought I’d confirm I see the same behaviour with the latest libreoffice binary (installed from .deb):

My command line is:

libreoffice7.6 --headless --convert-to 'pdf:draw_pdf_Export:{"SinglePageSheets":{"type":"boolean","value":"true"}}' '/www/html/pdf/output/SmallValidFile.xls' --outdir '/www/html/pdf/output'

libreoffice7.6 --version reports:
LibreOffice 7.6.2.1 56f7684011345957bbf33a7ee678afaf4d2ba333

Bug 156893 - Bug in the Whole Sheet export feature only exporting data upto 1022 rows