Re: How to get missing grid lines back?

[John Machin <sjmachin lexicon net>]

On 18/11/2009 1:51 PM, Larry Alkoff wrote:
> I have a spreadsheet started by a clever fellow that likes to "pretty 
> print" who has left the company.
>
> There are large sections of the spreadsheet with no grid lines.
> The cells exist because I can click on where a box should be and it is 
> outlined.

The cells exist unconditionally.

> Sometimes the vertical lines are missing, sometimes the horizontal 
> lines, sometimes both.  It's very disconcerting.
>
> Another thing is some of the grid lines that exist are bold, some are 
> not.  How did he do that?

Sounds like he has been playing with cell borders ("bold" == thick) 
and/or cell background colours using Format / Cells / (Border or 
Background). Note that borders and gridlines aren't the same thing. 
Borders are a property of each cell, displaying/hiding gridlines is a 
worksheet property which AFAICT affects only cell borders which haven't 
been changed from their default.

> How can I get grid lines back?

Change whatever border / background effects you don't like.

You may want to check for each worksheet what the gridline status is: 
switch to target worksheet, click on Format, click on Sheet. Gnumeric 
displays a tick next to "Hide Gridlines" if they are hidden using this 
method. Repeated clicking on Hide Gridlines cycles the state through 
(on, off).