On 05/04/2016 01:03 PM, Johnny Rosenberg wrote:
2016-05-04 19:23 GMT+02:00 Girvin R. Herr <[email protected]>:
You forgot the file global print grid option:
Format | Page | Sheet and check the Print | Grid box
That will print the grid on all rows that contain data. That is, it will
stop on the last row and column without any data. I use it all the time
when I want the grid printed, which is more often than not. When I need
more empty gridded cells on the page, I insert a period "." in a cell in
the last row I want the grid on.
Won't a space character work? Or at least something like =" "?
Kind regards
Johnny Rosenberg
Johnny,
Yes, I guess it would. I just prefer it not be too hidden and possibly
cause me problems downstream; forgetting it is there and not being able
to see it.
For example, a few weeks ago I was having a problem where my reference
to a cell in another sheet was displaying the formula, not the result
data from the other sheet. I was scratching what little hair I have
left until I discovered there was a space before the "=", which caused
Calc to interpret the reference as text, not the reference formula.
Arrgh! I wasted a lot of time on that one.
Thanks for the idea, though.
Girvin
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
