Calc Hide Grid when printing to PDF

[ResilientBuilding]

I use LibreOffice Calc to generate invoices for clients. I hide the grid (cell walls of the spreadsheet) to make a nicely formatted invoice. But when I go to save the sheet as a pdf, all the cell walls appear in the pdf version. How do I print a sheet without the spreadsheet grid?

I am using LibreOffice Calc version 6.4.6.2 on an Ubuntu 20.04.2 LTS machine.

Thank you!

[joshua4]

I’m not getting the grid using Export PDF in 7.2.2.2 on Mint, so I cannot test, but:

1. Tools>Options>LibreOffice Calc>View>Gridlines is independent of the checkbox for the sheet under View>Gridlines. Have you tried both?
2. A hack might be to format cells as white background with all borders set and set to white…

[ResilientBuilding]

Hi Joshua4, Thanks for helping me out! I tried your first suggestion. At first it didn’t seem to do anything. Then I realized it changes the grid display for the first three tabs, but not the 4th and last one, which is of course the invoice I need to print. But the grid is already hidden when I view it on my screen. The problem is it re-appears when I print.
I played around with Format>Cells>Borders but I don’t want to lose the borders I created to format the invoice. It’s not the same as the grid.

[LeroyG]

See LibreOffice Help on Printing Sheet Details. That includes Sheet grid.

Hope that helps.

[ResilientBuilding]

That did it! Last place I would have looked myself. Thank you!!!