Description of problem:
Exporting as PDF using the button also exports hidden sheets.
Steps to Reproduce:
1. Create multi-sheet work book
2. Hide several sheets
3. Export as PDF using button
A pdf file is created including hidden sheets
A pdf file is created without the hidden sheets
Is "Export hidden pages" selected if you use file->export as pdf ?
I can't find the "Export hidden pages" option in the export pdf options. What tab is it located?
The following tabs are present in my version: "General", "Initial View", "User Interface", "Links", "Security", and "Digital Signatures".
oh wait, you're talking about calc and spreadsheet sheets, not impress hidden slides. Impress has the include/don't include hidden slides feature, disregard that question.
In calc if I create a new spreadsheet with content on two slides and then hide one by right clicking on its tab and "hide sheets" and then export to pdf with the dialog or with the one click icon I get output pdf that does not contain the hidden sheets. So I can't reproduce.
For you does it make a difference to use the dialog vs single click icon ? Can you provide a reproducer document.
Created attachment 1276368 [details]
Using the dialogue and the single click yield to the same result.
Also, it seems that this issue cannot be reproduced when the workbook is created by Calc. I have a workbook that was created by MS Excel first.
caolanm->erack: any idea about this calc specific issue ?
The document has Print Ranges defined on each sheet, for sheet S2 the range $A$1:$I$52, so this is actually expected behaviour. To suppress from printing and PDF generation unhide/show the sheet and under menu Format -> Print Ranges -> Edit... set Print Range to -none- and then hide the sheet again.