I am exporting a spreadsheet to PDF and only the first sheet is exported. I've read the help and tried specifying the pages/range and still it is still only the first sheet that is exported.
Does anyone know what I am doing wrong please?
[Solved] Exporting Calc to PDF
[Solved] Exporting Calc to PDF
Last edited by prswan on Thu Mar 25, 2021 11:43 am, edited 1 time in total.
OpenOffice 4.1.8 on Mac OS 11.2.3
- Hagar Delest
- Moderator
- Posts: 32658
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: Exporting OO Calc to PDF
Hi and welcome to the forum!
I'm not a Calc expert but is a print range defined for each sheet?
Please add [Solved] at the beginning of the title in your first post (top of the topic) with the *EDIT button if your issue has been fixed.
I'm not a Calc expert but is a print range defined for each sheet?
Please add [Solved] at the beginning of the title in your first post (top of the topic) with the *EDIT button if your issue has been fixed.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Re: Exporting OO Calc to PDF
If only one sheet is exported, then that sheet probably has a defined print range but the others do not. Either remove the print range from the first sheet or define print ranges for all sheets.
AOO 4.1.14 on Ubuntu MATE 22.04
Re: Exporting OO Calc to PDF
File > Export as PDF > General > Range. Choose ALL pages.
The settings are "sticky" and are used when you click the PDF icon.
The settings are "sticky" and are used when you click the PDF icon.
- Attachments
-
- two sheets.ods
- (8.89 KiB) Downloaded 109 times
-
- two sheets.pdf
- (17.29 KiB) Downloaded 117 times
LO 6.4.4.2, Windows 10 Home 64 bit
See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.
Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.
Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
Re: Exporting OO Calc to PDF
Many thanks to these who replied, that has solved my problem (easy really...).
OpenOffice 4.1.8 on Mac OS 11.2.3
Re: [Solved] Exporting Calc to PDF
Which one? Cleaning up the print ranges or fixing the settings in the export dialog?prswan wrote:Many thanks to these who replied, that has solved my problem (easy really...).
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice