Ask Your Question

Export to PDF in Calc prints unwanted sheets

asked 2016-04-17 06:38:11 +0100

pmfrench gravatar image

updated 2020-09-12 08:11:40 +0100

Alex Kemp gravatar image

If I have a file in Calc with multiple sheets, define a single Print Range on one sheet, and export to pdf, it exports all data on other sheets in addition to the data from the defined print range on its sheet.

If I print to a printer, only the print range prints -- no data from other sheets in the file. I would expect that export to pdf would follow the same convention. The only way I've found to get that result is to print to a virtual pdf printer rather than use the built-in export to pdf function in LO.

Am I missing something?

edit retag flag offensive close merge delete


We have had the same experience and arrived at the same solution. I haven't had time to check LO help on this, but I suspected I was misinterpreting the purpose of the export to pdf menu bar button.

LKeithJordan gravatar imageLKeithJordan ( 2016-04-18 05:35:12 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2018-05-07 12:22:45 +0100

sroot gravatar image

I too was looking for the solution to this and found it here:

Short answer is Format > Print Ranges > Edit Then for the main print range set it to " - none - " instead of " - entire sheet - ".
Entire sheet is the default and I think that makes sense for basic users as printing and getting no output would be confusing. Where more advanced users have multiple sheets to print/export and need the flexibility, this dialog allows for that.

edit flag offensive delete link more

answered 2018-05-07 14:48:26 +0100

erAck gravatar image

Export as PDF is, surprise, an export of the document to PDF format, not printing; thus defined Print Ranges are not applicable. However, you can select a cell range and in the PDF Options, tab General choose Range Selection/Selected sheets.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-04-17 06:38:11 +0100

Seen: 1,189 times

Last updated: May 07 '18