Bug 1447830

Summary: Export as PDF button also exports hidden sheets
Product: [Fedora] Fedora Reporter: Basil Eric Rabi <ericbasil.rabi>
Component: libreofficeAssignee: Eike Rathke <erack>
Status: CLOSED NOTABUG QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 25CC: caolanm, dtardon, erack, ericbasil.rabi, mstahl, sbergman
Target Milestone: ---   
Target Release: ---   
Hardware: x86_64   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2017-05-09 17:09:58 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
Reproducer document none

Description Basil Eric Rabi 2017-05-04 01:36:37 UTC 
Description of problem:
Exporting as PDF using the button also exports hidden sheets.

Version-Release number:
5.2.6.2-6.fc25

Steps to Reproduce:
1. Create multi-sheet work book
2. Hide several sheets
3. Export as PDF using button

Actual results:
A pdf file is created including hidden sheets

Expected results:
A pdf file is created without the hidden sheets
Comment 1 Caolan McNamara 2017-05-04 09:33:52 UTC 
Is "Export hidden pages" selected if you use file->export as pdf ?
Comment 2 Basil Eric Rabi 2017-05-04 09:58:42 UTC 
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".
Comment 3 Caolan McNamara 2017-05-04 11:38:39 UTC 
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.
Comment 4 Basil Eric Rabi 2017-05-04 14:49:52 UTC 
Created attachment 1276368 [details]
Reproducer document

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.
Comment 5 Caolan McNamara 2017-05-05 13:31:12 UTC 
caolanm->erack: any idea about this calc specific issue ?
Comment 6 Eike Rathke 2017-05-09 17:09:58 UTC 
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.