What is equivalent soffice command for the respective UI attached that Include Whole Sheet Export checkbox option under Structure UI options

[srikant2208]

Description:
I have a .xlsx document with different Hyperlink provide as internal components that contains large tables and data that is not fitting in to the exported pdf and as result it creating tiny table that is not readable this replicable with default setting and Range - >All

Solution through UI:
To get readable format we just tried to use Stucture → Whole sheet Export checkbox options and get exported pdf as the attachment

Steps to Reproduce:

1. Open up the .xlsx file
2. select Range ->All
3. Ctrl+s to save the document (not sure if necessary)
4. Click file->export as pdf
5. Getting 1000 of blank pdf pages and tiny tables

Solution steps via UI:

1. Open up the .xlsx file
2. select Range ->All
3. Ctrl+s to save the document (not sure if necessary)
4. Click file->export as pdf
5. Check ‘Whole sheet export’
6. Click Export
7. Now getting a readable output files with 25 pdf pages.

Expected Info: I want do the solution part via using soffice command filter and not able to achieve the same result

Note: please Suggest the command to achieve the solution step via Soffice command line

Already tried commands and filters:
soffice --headless --convert-to pdf:“calc_pdf_Export:ExportWholePageChecked:1” -outdir [output directory] [input Excel file path]
soffice --headless --convert-to pdf:“calc_pdf_Export:SelectPdfVersion:1,ExportWholePageChecked:1,SelectionOnlyChecked:0,UseLosslessCompression:1” -outdir [output directory] [input Excel file path]

soffice --headless --convert-to pdf:“calc_pdf_Export:ExportWholePageChecked:1” -outdir [output directory] [input Excel file path]

soffice --headless --convert-to pdf:“calc_pdf_Export:SelectPdfVersion:1,ExportWholePageChecked:1,SelectionOnlyChecked:0” --outdir [output directory] [input Excel file path]

Reproducible: Always

[mikekaganski]

Libreoffice .xls to .pdf conversion breaks single page content into multiple pages on Ubuntu 18.04

2022-11-04: updated to mention the command line syntax available since version 7.4. First of all, you used a wrong export filter name in your command line. As explained here, in this case you (not) needed to use calc_pdf_Export, which is used by default anyway when you export a document handled by Calc and use pdf output specification. But that will not change anything. Until version 6.4, there was no way to do what you need. In 6.4, a Full-Sheet Previews feature (supposedly to be renamed soon…

[srikant2208]

currently I am using libre office 7.2.7.2 version to replicate the issue, do we able to specify command for the above UI setting with Whole sheet Export checkbox options?

[mikekaganski]

You could read the linked answer, and see that it explains both the pre-7.4 solution (the first one, requiring a pre-created user profile, because there was no way to specify the option through command line), and the one available since 7.4 (in the end of the answer). Can you please suggest an improvement of wording, to make that clearer?