Description: LO 7.5.0.3 doesn't print a selected sheet, neither in landscape or portrait. Only an empty page is printed. Steps to Reproduce: 1. Have multiple sheets in an ODS, that have data on it 2. Try to print Actual Results: Preview and print are a single empty page Expected Results: Preview and print with actual data. Either multiple pages or a single page with data resized to fit to page. Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: en-US Module: SpreadsheetDocument [Information guessed from browser] OS: Windows (All) OS is 64bit: yes Version: 7.5.0.3 (X86_64) / LibreOffice Community Build ID: c21113d003cd3efa8c53188764377a8272d9d6de CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: de-DE (de_DE); UI: en-US Calc: threaded
Safe-Mode didn't solve it, so not a profile issue.
Please attach a sample file? What do you have selected in Menu/Format/Print ranges/Edit?
Created attachment 185724 [details] Example sheet for bug 153906
Created attachment 185725 [details] Screenshot of Bug 153906
I want to print the selected sheet. Attached exmaple and screenshot of issue. If you change the order of the sheets (e.g. move 1st to the end) then you get an empty preview/print.
In Menu/Format/Print ranges/Edit, you have -none- selected. Use Menu/Format/Print ranges/Clear and then you have in Menu/Format/Print ranges/Edit, the Print Range to - entire sheet - https://help.libreoffice.org/latest/en-US/text/scalc/guide/printranges.html?DbPAR=CALC#bm_id14648 Please, if you have questions like this one in the future, look for help first in our forum https://ask.libreoffice.org/
This is not resolved, if I go for "selected sheets" then it should print the selected sheets, and should need to define print areas everywhere. If I want to print special areas I would select "Print Selected Cells" etc. From User Experience that's bad behavior, at least it could inform about missing print ranges on any of the selected sheets. Please enhance your user experience.
Additional it shows the print area of not selected sheet, that's also wrong behavior.
First you must do Menu/Format/Print ranges/Clear I have just tested, then Print Selected sheets and selected cells works fine.
I ask you to step back from your position inside LO, and take the point of view of a first time user of LO (maybe even coming from MS Excel). 1. If user chooses "Print Selected Sheets", then LO must not consider print ranges from any non-selected sheet. To me this is actually a bug. 2. If a print range is missing on any of the selected sheets, then LO should help the user . Either (A) inform him about the sheets (list) that are missing a print range plus a link to the LO docs about print ranges. Additionally it skip those sheets to avoid "empty" pages. Or (B) LO takes all the content from A1 to the last filled column and row as an implicit print range. Maybe this point should be considered by LO's UI team to define what the user experience should be.