Apache OpenOffice Community Forum

I want to hide the gridlines on a spreadsheet when it's opened
(Not just for printing it) but I don't see that option in View

I finally found the right set of tools.

More steps and harder to find than the same things in Excel.

If you are accustomed to one tool, then a different tool always seems unintuitive or needlessly complex. When I have to make a graph in Excel, I am driven insane by the process needed to make a decent looking one. When I make one in R, a far more difficult software to learn, it seems easy because I am used to that. I suspect that once you use Calc for a while, it will seem just as easy to use as Excel seems now. However, if you are going to spend the rest of your life thinking "this is easier in Excel", then use Excel.

Just for other Forum members reading this post, the solution is:

From the Menu: Tools -> Options... -> OpenOffice Calc -> View -> Grid Lines
The above Grid Lines should NOT have a check mark, if you do NOT want to see any grid lines on the screen.

[color=#0040FF]Calc Help[/color]: [b]grids;hiding lines in sheets [/b] wrote:
Changing Table Views
To hide column and line headers in a table:

• Under the menu item Tools - Options - OpenOffice Calc, go to the View tab page.
  Unmark Column/row headers. Confirm with OK.

To hide grid lines:

• Under the menu item Tools - Options - OpenOffice Calc, go to the View tab page.
  Unmark Grid lines. Confirm with OK.

Sliderule

There is also an extension allowing to hide/show the gridlines per sheet.
(The setting is not saved to the file. The command needs to be added manually to a menu and/or toolbar.)
See https://extensions.openoffice.org/en/project/gridlines.