Created attachment 176464 [details] File does not print properly Completely stymied by this behaviour for the last hour. Tried to copy elements around, to new sheet etc. to make it work but no go. Removed the text, still no go. I suppose it's something in the structure of the header rows that causes printing to fail. This is a multi-page sheet. It displays correctly in "print preview" but when selecting "print" the top range of pages (containing the "header lines") is not generated, either in the mini-window "print preview" or the printer. Although one sometimes gets a "topmost rightmost" sheet with two header columns that is still generated. This is on Linux Fedora 33: 5.14.18-100.fc33.x86_64 Attaching sheet.
Created attachment 176465 [details] Screenshot of the print preview dialog after "print" has been selected
Created attachment 176466 [details] Screenshot of the print preview dialog after "print" has been selected
Thank you for reporting the bug. it seems you're using an old version of LibreOffice. Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.
Similarly: If one wants to restrict oneself to the top left for example, one can set the print ranges from A1 to Q12. The printout can then be set to 1 sheet. The result is "No Data" in print preview.
Ok, let me try this. I have a never one somewhere...
This is Menu/Tools/Options/LibreOffice Calc/Print - Suppress output of empty pages, that it's enable in the file, giving a different result in the print preview than the view on the print dialog. With it disable looks the same. Maybe because cells are empty only formats in them. Version: 7.2.3.2 (x64) / LibreOffice Community Build ID: d166454616c1632304285822f9c83ce2e660fd92 CPU threads: 4; OS: Windows 10.0 Build 21390; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL
(In reply to m.a.riosv from comment #6) > This is Menu/Tools/Options/LibreOffice Calc/Print - Suppress output of empty > pages Good take. I checked: 1) The printout is configured to be distributed over a width=3 x height=4 set of pages, as configured in "Format > Page". 2) The "print preview" shows width=3 x height=3 pages because that's sufficient. This includes the "header rows" (which are the first 4 rows, in light blue) 3a) When "Suppress output of empty pages" is **on** in the dialog that appears when you hit "print", the "mini print preview" in that dialog shows width=3 x height=3 pages. But, contrary to "print preview" it does not render the "header rows". 3b) When "Suppress output of empty pages" is **off** in the dialog that appears when you hit "print", the "mini print preview" in that dialog shows width=3 x height=4 pages and renders the "header rows" correctly. Check on LibreOffice 7.1.7.2 on Fedora 34. Either the configuration works in a way that I really don't understand or the renderer considers pages as "empty" that are not empty for some reason.