What about the zoom level?
1 Like
I want the grid to print. I just want it to print in the correct spot and not on top of the text.
I will check that and make sure all is as it should be.
If it will help I will post a sample when I get home. I thought the screenshot would suffice.
I have experimented with printing to a couple of different pdf printers and with a few different versions of LibreOffice. It seems the overlap with the grid lines when printing to pdf is confined to 24.8, I don’t see it in 24.2, nor in 25.2 (pre-release). The file also seems to ignore default paper size in LO and Adobe when printing with Adobe Acrobat X
.
A file created with 24.8.4.2 but opened in other versions also has the issue of printing text over the grid.
.
PrintGrid116693_24-8-4-2.ods (10.5 KB)
PrintGrid116693_24-8-4-2.pdf (33.2 KB)
Same or worse with Export to PDF
ExportGrid116693.pdf (20.4 KB)
Maybe revert to 24.2 or try pre-release 25-2
I did not test on 24.8.3.2, maybe that is OK.
2 Likes
Thank you very much!! I will change to one of those. I am so glad to have a solution for this!
I just tried 25.2 and the problem persists. I will try to revert to 24.2 tomorrow.
Sorry, the problem exists in 25.2.0.2; I tested on 25.2.0.1 which was fine.
Bug posted Bug 164744 - Printing or Export to PDF Text is pushed up over grid lines on multi-line cell
3 Likes
Thank you very much for the clarification.
I downloaded this version and am still experiencing the issue. I will try 24.2 and see what happens.
Version: 25.2.0.1 (X86_64) / LibreOffice Community
Build ID: ddb2a7ea3a8857aae619555f1a8743e430e146c9
CPU threads: 12; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded
Note my comment that a file made or edited in 24.8.4.2 retains the issue when opened in another version of LibreOffice.
1 Like
Aww man…I completely missed that. Thank you very much. So if I copy the contents of the file and paste it into a new document in 25.2 that should fix it, right? I feel like it should but I would rather ask a dumb question than waste more of my time trying stuff that won’t work.
Well that didn’t work. Is there some way to transfer the contents of my documents to documents that will print correctly without retyping it all?
Paste as unformatted text?
[Edit]
If you open the spreadsheet in one of the non-affected versions, you could select the ranges and press Ctrl+M to clear direct formatting. Reformat the cells and they will export OK
1 Like
Thank you. I will try this and let you know.
So I have this version installed:
Version: 25.2.0.1 (X86_64) / LibreOffice Community
Build ID: ddb2a7ea3a8857aae619555f1a8743e430e146c9
CPU threads: 12; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded
I typed up an entirely new document. When I went to print preview the grid lines were still intersecting the text.
I didn’t see the issue in that version. Maybe you could add 25.2.0.1 and the sample to the bug report.
I opened the spreadsheet in a version that I believe you advised. I then cleared direct formatting, saved the document, closed and reopened it, and then reformatted the entire thing. When attempting to print or save as pdf I am still experiencing grid lines intersecting lines of text. I am using this version:
Version: 24.2.7.2 (X86_64) / LibreOffice Community
Build ID: ee3885777aa7032db5a9b65deec9457448a91162
CPU threads: 12; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded
If this one is not what I should be using please advise. You had said that 24.2 was ok but I was not sure which 24.2 I should use and tried this one.
I was reporting only what I found but it turns out that the bug might be a lot older, see the bug report again. You should add yourself to the CC list for the bug report so you can get any updates.
1 Like
Will do-thank you very much for your efforts!