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.
Dear David Tonhofer, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug