2016-05-04 19:23 GMT+02:00 Girvin R. Herr <gherr...@sbcglobal.net>: > > > On 05/03/2016 08:53 PM, Brian Barker wrote: > >> At 21:42 03/05/2016 -0400, John Caruso wrote: >> >>> I have given up on OO because I could not get grid lines in Calc 4.1.2, >>> I found an old copy of office10 and installed it and now I get grid lines >>> in Excel with no problem >>> >> >> I'm not sure what you mean by "office10": is that version 10.0 of >> Microsoft Office, i.e. Microsoft Office XP? Or perhaps you mean Microsoft >> Office 2010? But no matter. >> >> I'm always amused when people write to the Users list to say that cannot >> use the product. It is perhaps understandable that you should find some >> difficulty or other, but choosing to advertise to thousands of generally >> satisfied users that you are unable to make the product do what you need >> seems somewhat weird. >> >> Grid lines show by default in Open Office spreadsheets, so readers will >> wonder what you are doing wrong. If they don't show, you can restore them >> at Tools | Options... | OpenOffice Calc | View | Visual aids | Grid lines. >> If you see new documents as not displaying the grid. you must be using a >> template - perhaps even a default template - which has display of the grid >> disabled. >> >> Note that the purpose of the grid is to guide the eye in the editing >> window: it does not appear in the printed output as it is not intended for >> that purpose. If you want spreadsheet cells to be outlined in the printed >> output, you need to format your cells to have *borders*. You can do this >> very flexibly on the Borders tab of the Format Cells dialogue (or using the >> Borders button in the Formatting toolbar). In general, you will want to be >> very selective about which cells have which arrangement of borders set to >> what style and colour. But it is possible to mimic the grid (if that is >> what you need) by setting similar borders to all cells: simply select all >> cells before you do this, using Edit | Select All (or Ctrl+A) or by >> clicking the rectangle at the top left, where the row and column headers >> meet. >> >> Incidentally, you have again hijacked an existing thread by creating your >> message as a reply to it when it was nothing of the sort (and without even >> changing the Subject header). As I mentioned before, this is not only >> discourteous to others but is also unhelpful to you: your message will be >> buried in the existing thread and may well not be seen by anyone not >> interested in the earlier topic. >> >> I trust this helps. >> >> Brian Barker >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org >> For additional commands, e-mail: users-h...@openoffice.apache.org >> >> >> Brian, > 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 > That is not very noticeable when printed and it does the job. > HTH > Girvin Herr > >
