Donate SIGN UP

Open Office Calc

Avatar Image
MichaelZZ | 08:03 Wed 23rd Mar 2011 | Computers
5 Answers
I have been using OOo (Writer, Calc and Impress) for some time and am perfectly happy with it. Yesterday, I downloaded the latest version (3.3) and now when I open a new Calc spreadsheet I can only see the row and column headers but the main body of the spreadsheet, where I would expect the grid lines to be, is blank. Is there a way of showing the grid lines by default, just as it used to be in previous editions (and, indeed, in Excel and Lotus 1-2-3)?
Thanks in advance
Gravatar

Answers

1 to 5 of 5rss feed

Best Answer

No best answer has yet been selected by MichaelZZ. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Don't think that has owt to do with 3.3 which works fine for me.
You haven't by any chance set the view to "Page Break Preview"?
That removes the grid lines and changes the background colour.
Question Author
Thanks for your reply Rojash. No, I haven't set the view to Page Break Preview, it's on "Normal". (I have just tried to see what happens with Page Break Preview and, as you say, it changes background colour to grey - and it also reduces cell size somewhat. I've changed back to "Normal" and still don't have any grid lines.)
I've uninstalled and reinstalled and still have the problem.
Is there not a checkbox somewhere, as in Lotus 1-2-3, that enables you to toggle between showing and not showing grid lines? I know I can format cells so that gridlines will print but I was after something "global" by default.
Tools/Options
OpenOffice.org Calc
View, check Grid lines.

This is the default.
Question Author
That's it!

Thanks very much Rojash. Fairly well hidden though, wasn't it?

Thanks again!
"Fairly well hidden though, wasn't it? "

Useful things always are; it's a tradition or an old charter or something. :)

1 to 5 of 5rss feed

Do you know the answer?

Open Office Calc

Answer Question >>