Export to PDF in Calc prints unwanted sheets

[pmfrench]

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?

[LKeithJordan]

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.

[sroot]

I too was looking for the solution to this and found it here:
https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=54655

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.

[erAck]

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.