Printing gridlines for a spreadsheet

Discuss the spreadsheet application

Printing gridlines for a spreadsheet

Postby sherriflake » Mon Aug 29, 2011 11:25 pm

When printing a spreadsheet from CALC, the bottom half of the spreadsheet does not print the grid lines. I have formatted the cells with borders, and they also do not print. This has been an ongoing problem even with a previous computer that ran Windows XP. I am now using a new computer with Windows 7.
Open Office 3.3 Windows 7
sherriflake
 
Posts: 3
Joined: Mon Aug 29, 2011 11:21 pm

Re: Printing gridlines for a spreadsheet

Postby swingkyd » Tue Aug 30, 2011 12:22 am

Can you post a copy of the spreadsheet on the forum?
swingkyd
 
Posts: 24
Joined: Sat Jan 05, 2008 8:31 pm

Re: Printing gridlines for a spreadsheet

Postby acknak » Tue Aug 30, 2011 12:37 am

By default, Calc doesn't print empty cells.

If you want to print an empty grid, you can set up a print range: select a range of cells, then Format > Print Range > Define.
AOO 4 • Linux • Fedora 17
User avatar
acknak
Moderator
 
Posts: 17420
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Printing gridlines for a spreadsheet

Postby sherriflake » Wed Sep 07, 2011 6:31 pm

Thank you for the replies. The suggestions were followed, and the problem remained. Some of the empty cells DO have the grid lines printed, but only on the top portion of the sheet. The lines DO show in the print preview, but they do not print on the page. Might this be a printer issue? It was suggested that I post a copy of the spreadsheet. I do not find an option to attach. Would appreciate instructions on how to post a copy of the spreadsheet.
sherriflake
 
Posts: 3
Joined: Mon Aug 29, 2011 11:21 pm

Re: Printing gridlines for a spreadsheet

Postby thomasjk » Wed Sep 07, 2011 6:40 pm

Instructions here viewtopic.php?f=74&t=8289
Tom K.
Windows 7 Home Premium
LibreOffice 4.2.3.3
thomasjk
Moderator
 
Posts: 3602
Joined: Tue Dec 25, 2007 4:52 pm
Location: North Carolina

Re: Printing gridlines for a spreadsheet

Postby acknak » Wed Sep 07, 2011 8:18 pm

sherriflake wrote:... The lines DO show in the print preview, but they do not print on the page. Might this be a printer issue?

Could well be the printer or printer driver software. Sometimes an update to the latest printer software can cure a glitch like this.

Here's an empty grid (2 pages) you can try; it prints fine for me.

You can also try exporting the sheet to pdf, then print the pdf from your pdf viewer application. That's usually an effective workaround to get something on paper.
Attachments
page_grid.ods
(8.1 KiB) Downloaded 266 times
AOO 4 • Linux • Fedora 17
User avatar
acknak
Moderator
 
Posts: 17420
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Printing gridlines for a spreadsheet

Postby sherriflake » Wed Sep 07, 2011 8:50 pm

Thank you, acnak!! The page you attached had the same problem. I exported my file to pdf, opened it with adobe acrobat reader, and it printed from there WITH the gridlines! Soon I will address the printer issue.
Open Office 3.3 Windows 7
sherriflake
 
Posts: 3
Joined: Mon Aug 29, 2011 11:21 pm

Re: Printing gridlines for a spreadsheet

Postby RoryOF » Wed Sep 07, 2011 11:37 pm

It may be that you need to change the printing resolution of your printer, as the lines may be vanishing because of cumulative arithmetic errors. Alternately, is it possible to increase the width of the default grid line - if so, try doubling it's weight.
Apache OpenOffice 4.0.1 on Xubuntu 13.10 and Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 14370
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland


Return to Calc

Who is online

Users browsing this forum: Richarda44, RusselB and 30 guests