Description: Text clearly in one cell in calc has been printed as if in the next cell up. Leading me to attend a shift I wasn't booked on. It is an .xlsx spreadsheet presumably created by a microsoft product, which looks correct when opened on screen either in calc under ubuntu or sheets under android. However, when printed on a brother HL-1210W shows the first line of the text in cell E39 printed over the cell E38, with the remaining lines in E39. I had to adjust the format before I printed it (to force landscape and A4, as libreoffice doesn't understand that I am in the UK and would never want Letter) I have so far tried to recreate it using a subset of the doc and it printed ok, so will later try and recreate all the steps. But I wanted to get the warning out as this could be very serious. Steps to Reproduce: 1. Working on it. 2. 3. Actual Results: I will attach photos of the screen copy and the printout and follow up with another attempt at reproducing it. Expected Results: I will attach photos of the screen copy and the printout and follow up with another attempt at reproducing it. Reproducible: Couldn't Reproduce User Profile Reset: No Additional Info: I will attach photos of the screen copy and the printout and follow up with another attempt at reproducing it.
Created attachment 187432 [details] what you see on the screen, correct
Created attachment 187433 [details] photo of the printout - wrong
I have now reproduced it. The original spreadsheet was poorly formatted for printing so I had to do a number of things: 1. Set to A4 2. Set to landscape 3. adjust some column widths to a) remove ### issues and b) make it fit within a single page width 4. delete some almost-blank lines that would have wasted paper This recreated the exact same error as illustrated. I also notice other formatting problems, all associated with the content of columns that I had to reduce in width. My guess is that Calc is wrongly calculating (too little height) the row height when sending a column that has been narrowed to the printer.
Thank you for the report. I wasn't able to reproduce using your steps and: Version: 7.3.7.2 / LibreOffice Community Build ID: e114eadc50a9ff8d8c8a0567d6da8f454beeb84f CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded In any case, 7.3 will not see further releases, so please test again with LO 7.5 and see if you can still reproduce. If you can, please paste here the info from Help > About LibreOffice, and provide an example file that we can directly print. Thank you!
Dear Stuart Gillies, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping
You are asking for a file to check but the file in question contains confidential info and I cannot provide it. As the SW version is now old I assume that if the bug persists in a later version others will report it.
I assume the issue isn't related to only printing a cell range selection? If you do restrict to a cell selection, I'm wondering if you are experiencing bug 137263. (In reply to Stuart Gillies from comment #6) > You are asking for a file to check but the file in question contains > confidential info and I cannot provide it. Any chance you can reduce the file and replace the sensitive information with sample text? https://wiki.documentfoundation.org/QA/Bugzilla/Sanitizing_Files_Before_Submission Or provide which Alignment options are used for the cell that contains the text. If you are still using a version older than 7.5, also see if this setting has any effect: Tools > Options > Calc > Use printer metrics. (The option was removed in 7.5.) https://ask.libreoffice.org/t/calc-text-does-not-fit-in-cell-when-printing-exporting-to-pdf/21494