Un-displaying the grid lines in OpenOffice.org Calc

Tired of those pesky gridlines being displayed onscreen? Here's how to turn them off.

Thanks to Marek for pointing this out -- I like to consider myself the queen of "it's under tools > options" but I only looked under the View menu before resorting to hack measures.

Choose Tools > Options > Calc, View. Deselect Grid Lines. You can change the color of the grid lines here, too.

Note that by default, they don't print. To make them print, choose Format > Page, Sheet tab.

---

---

Comments

[Niraj]

i need to create a graph. i want to display the x-axis and y-axis grids only selectively. meaning every 3rd or 4th grid line should be displayed not all. also is there any way to change the color of only one particular grid line.

Thanks,
niraj

[Solveig]

Hi Niraj,

To change the color of just one bar (not grid line), you can double-click the chart, click on the bar area, and click again on the individual bar to change. Right-click, choose Object Properties, then Area tab. I don't think you can selectively change grid line color; you'd have to just draw a new grid line using the drawing tools and put it on top.

Or paste the whole chart into Draw, right-click, choose Break, then select the grid lines you want to delete, and the one you want to re-color. See this entry.
http://openoffice.blogs.com/openoffice/2008/06/making-changes-to-an-openofficeorg-chart-in-draw.html

[Brian Fenton]

Hi,

this is a very useful blog! I wonder if you know the answer to my question. I'm exporting Calc files to PDF from OpenOffice and I would like to display the grid lines in the exported PDF file. Any idea how to turn them on?

thanks!
Brian