Description: PDF export in LibreOffice Calc doesn't handle any page settings, it doesn't even respect the print settings. It will export a sheet as it is into a PDF. For example, it is not possible to set 2 A4 pages on a A3 page just like in the print windows. LibreOffice Calc should provide a way to set how we want the PDF to be exported in order to create better PDF exports. Especially, to create a PDF file identically watever the system settings are. Plus it would close Bug 155124 on macOS. https://bugs.documentfoundation.org/show_bug.cgi?id=155124 The export PDF feature should provide these settings: - Page size (with custem sizes allowed) - Export all sheets - Page orientation (Portrait or Lanscape) - Number of pages on each page - Pass over blank pages Actual Results: Calc sheets are exported as they are displayed on screen. Expected Results: Settings should provide improved page settings. Reproducible: Always User Profile Reset: No Additional Info: /
Created attachment 188405 [details] Print settings with the options that should be enabled in PDF exports
Created attachment 188406 [details] Remove blank page feature that should be enabled in PDF exports
I don't think we should replicate all the options available in the print dialog. It looks like you are after using the Print dialog and "printing to file" to end up with the document you want. As I understand it, PDFs are supposed to be a digital document true to the original document, with some added options for interaction with the user and accessibility features. This is why the dialog offers less options around layout, page size, etc, as it follows what is already set up in the document. Doesn't "print to file" cover your use case already? Regarding your list: - page size: can be changed in Format > Page Style - export all sheets: I believe that's what "All" does in the PDF Export dialog? - page orientation: can be changed in Format > Page Style
There is this long standing bug on macOS making Print to PDF almost unusable as I wrote above. https://bugs.documentfoundation.org/show_bug.cgi?id=155124 Plus the paper size is related to the papers supported by the printer itself. So If I want a A3 or even a A0, while the printer only handle 14, you cannot export your document. While having a direct PDF export wouldn't limit this. Plus, in the case of Calc, having better page settings features would improve the experience with building digital documents, because Calc is not only a table with cells. It's a whole documents with tons of functions and settings that as you interactions features. And since the OLE doesn't work properly to embed Calc pages in other documents in order to achieve this.
I forgot to my previous comment, export to PDF is the only way to build a signed PDF. So if we want to build a certain page layout in Calc with the different available settings, like the print zones, we have the choice to have a signed PDF with a no settings available, or to have a layout matching perfectly well all the settings, but with an unsigned document.
[Automated Action] NeedInfo-To-Unconfirmed
UX/design team, what do you think?
"Print to File" uses the paper size from the available printer, which has been reported before for instance in bug 152272. Many websites offer the service to resize documents. We should provide this option in first place at the "Export to PDF" dialog. Not sure what to handle here or on the other ticket(s).