[Solved] Printing grid lines in Calc

Discuss the spreadsheet application
Post Reply
silveranchor
Posts: 3
Joined: Thu Nov 22, 2007 2:58 pm

[Solved] Printing grid lines in Calc

Post by silveranchor »

I have just printed out some lists of contacts and as I have three columns I would like the grid lines to show.
I have searched the forum but unable to find how to do this can anyone help please.
Many Thanks
John.
Last edited by Hagar Delest on Tue Jul 26, 2011 9:41 pm, edited 1 time in total.
Reason: tagged [Solved].
RonIA
Volunteer
Posts: 139
Joined: Mon Oct 08, 2007 1:34 am
Location: Iowa USA

Re: Printing grid lines in calc.

Post by RonIA »

Format - Page - Sheet tab
Select under Print - Grid
Ron from Iowa, USA
silveranchor
Posts: 3
Joined: Thu Nov 22, 2007 2:58 pm

Re: Printing grid lines in calc.

Post by silveranchor »

Many Thanks Ron much appreciated.
John.
RonIA
Volunteer
Posts: 139
Joined: Mon Oct 08, 2007 1:34 am
Location: Iowa USA

Re: Printing grid lines in calc.

Post by RonIA »

You are welcome.

Has your question been answered? Then please add [solved] to the title of your thread.
Ron from Iowa, USA
jmelees
Posts: 1
Joined: Tue Jul 26, 2011 7:18 pm

Re: Printing grid lines in calc.

Post by jmelees »

in Calc 3.3.0 here are the directions that I used.

Grid lines- Specifies whether to display grid lines between the cells. For printing, choose Format - Page - Sheet and mark the Grid check box.
Open Office 3.3.0 on Windows 7
cande374
Posts: 1
Joined: Fri Jan 28, 2011 1:01 am

Re: [Solved] Printing grid lines in Calc

Post by cande374 »

Thank you so much for posting the solution to this issue. I knew there had to be an easy way to solve this problem. I could not figure out the solution through the help file. Just wanted to say I really appreciate the RON IA for taking time to post solution.

format - page - sheet - grid (click on grid)

worked for me to print grid lines on final print.

TRY THIS SOLUTION BEFORE DOING OTHER WEIRD THINGS THAT MIGHT HAVE BEEN POSTED LIKE CHANGING PRINT DRIVER, ETC.

Colinf
openoffice 3.1 on Windows xp
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: [Solved] Printing grid lines in Calc

Post by Villeroy »

I could not figure out the solution through the help file.
1) Hit F1, choose Calc from the top-left list box, select the index tab, type "grid", pick "printing sheet grids".

2) Visit this web-site, type "print grid" into the upper-right corner and hit Enter.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
DFW333
Posts: 18
Joined: Sat Oct 04, 2014 1:58 am

Re: [Solved] Printing grid lines in Calc

Post by DFW333 »

I am having this same problem. The posts above partially solved the problem. Unfortunately it doesn't print grid lines unless there is text in the cell. I need it to print the blank cells also.
Open Office 4.1.4
Windows 7 Home Premium 64-Bit (6.1, Build 7601)
User avatar
Zizi64
Volunteer
Posts: 11352
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: [Solved] Printing grid lines in Calc

Post by Zizi64 »

Just put a dot (.) or other small sized character into the last cell you want to print.
You can set the color of the character to white. The cells of the non empty sheets (until the last non-empty cells) will be printed.
(And You can unheck the "Suppress output empty pages" parameter in the Tools - Options - Libre/openOffice Calc - Print - pages menu item - if you need it.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Post Reply