Description: I have a excel file with 4 sheets in it. Scenario 1: Theare are 4 sheets in the excel file. 2 sheets are visible and 2 sheets are hidden. Exporting to pdf exporting 2 visible sheets and this is as expected. Scenario 2: Theare are 4 sheets in the excel file. All 4 sheets are added to Print Ranges and again 2 sheets are visible and 2 sheets are hidden. Exporting to PDF is exporting all the sheets including hidden sheets. This is not as expected. Steps to Reproduce: 1.Open the attached excel and exported to PDF. 2.Exported pdf has 4 pages i.e., 4 sheets are exported though 2 sheets are hidden. 3.Clear the Print Range of all pages and hide the sheet 3 and 4 and export to pdf again. 4. This time only visible sheets are exporting. Actual Results: All 4 sheets are exported to pdf though 2 sheets are hidden. Expected Results: Only visible sheets should be exported. Please note MS office is exporting only visible sheets even though all sheets are added into Print Areas. where as Libre office exporting hidden sheets also. Reproducible: Always User Profile Reset: No Additional Info: Should export only visible sheets.
Created attachment 196642 [details] Sample file
Repro, already in 3.5. Not dependent on XLSX format. Arch Linux 64-bit Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 46ce77dfffaa6445ed05e1400284f4f9491b9faf CPU threads: 8; OS: Linux 6.12; UI render: default; VCL: kf6 (cairo+wayland) Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: CL threaded Built on 10 December 2024