OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

How to print the borders of empty cells [solved]

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
Ewald
OOo Advocate
OOo Advocate


Joined: 16 Dec 2005
Posts: 392

PostPosted: Sat Aug 08, 2009 3:03 am    Post subject: How to print the borders of empty cells [solved] Reply with quote

I'd like to print out a form to be filled in using the archaic method of handwriting but I can't get the empty cells to be printed with borders. Can anyone give me a hint?

Last edited by Ewald on Sat Aug 08, 2009 6:58 am; edited 1 time in total
Back to top
View user's profile Send private message
probe1
Moderator
Moderator


Joined: 18 Aug 2004
Posts: 2560
Location: Chonburi Thailand Asia

PostPosted: Sat Aug 08, 2009 3:17 am    Post subject: Reply with quote

F1 Online Help
Format>Page...>Sheet>Print>Grid
_________________
Cheers
Winfried
My Macros
DateTime2 extension: insert date, time or timestamp, formatted to your needs
Back to top
View user's profile Send private message Visit poster's website
JohnV
Administrator
Administrator


Joined: 07 Mar 2003
Posts: 9183
Location: Lexinton, Kentucky, USA

PostPosted: Sat Aug 08, 2009 3:24 am    Post subject: Reply with quote

The borders displayed in Calc are for display purposes only so you have to do real borders. Select a range, do Format > Cells > Borders tab, select a Style and to the left click the 4th icon. Put a space in the last cell in the range so OOo won't refuse to print a blank area and print.
Back to top
View user's profile Send private message
Ewald
OOo Advocate
OOo Advocate


Joined: 16 Dec 2005
Posts: 392

PostPosted: Sat Aug 08, 2009 3:26 am    Post subject: Reply with quote

I tried that but it didn't help. I also checked any print ranges, tried to copy the whole sheet to a new file with default settings, I just can't get it to work somehow. I know I did this before but with this file no luck!
Back to top
View user's profile Send private message
james_h
Super User
Super User


Joined: 05 Nov 2005
Posts: 883

PostPosted: Sat Aug 08, 2009 5:37 am    Post subject: OOo 3 Calc - How to format a cell with a border Reply with quote

Click a cell to be printed with a border.
Format > Cells > Border
Under Line Style, choose a line width and a colour.
Under Line Arrangement, Default, click the icon with the Tool tip Set All Four Borders.
Click OK.
Repeat for each cell to be formatted with a border.
Back to top
View user's profile Send private message
Ewald
OOo Advocate
OOo Advocate


Joined: 16 Dec 2005
Posts: 392

PostPosted: Sat Aug 08, 2009 6:55 am    Post subject: Reply with quote

Thanks for your help guys, I did tried all your suggestions and while messing around I found out about the real problem:
The borders of empty cells don't show up in the page preview which I used for testing the result assuming that the page preview would be a real preview which apparently it isn't since when I actually print from a preview not showing the borders the borders are still printed. Bummer!
Back to top
View user's profile Send private message
jrkrideau
Super User
Super User


Joined: 08 Aug 2005
Posts: 6732
Location: Kingston ON Canada

PostPosted: Sun Aug 09, 2009 9:15 am    Post subject: Reply with quote

Ewald wrote:
Thanks for your help guys, I did tried all your suggestions and while messing around I found out about the real problem:
The borders of empty cells don't show up in the page preview which I used for testing the result assuming that the page preview would be a real preview which apparently it isn't since when I actually print from a preview not showing the borders the borders are still printed. Bummer!


I just tried that. I think you may have found a bug or perhaps an undocumented feature. I see that the grid appears as soon as even one cell has anything in it.
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2
Back to top
View user's profile Send private message
Altvamp
Newbie
Newbie


Joined: 15 Oct 2013
Posts: 1

PostPosted: Tue Oct 15, 2013 1:00 pm    Post subject: Calc not printing empty cells Reply with quote

I am not sure if this is the same problem but I suspect it is, I am trying to print a single page area of one filled in column and 5 empty ones for people to write in, There is a border and I'm sure in Excel this would ensure the empty columns would print, but it seems in Open Office it will not print empty columns even with borders, the only way I can get it to print the full page of empty columns is to put some character (space does work) in one of the far right cells. I've tried the suggestions here with no success and although I can do it by putting a space or non visible character in one of the far right cells it does not seem right to have to do this.
Back to top
View user's profile Send private message
JohnV
Administrator
Administrator


Joined: 07 Mar 2003
Posts: 9183
Location: Lexinton, Kentucky, USA

PostPosted: Wed Oct 16, 2013 9:53 am    Post subject: Reply with quote

I selected the empty range A1:C10, did Format > Cells > Border tab, selected the small line, clicked the icon with all cells having borders and OKed out. All cells in A1:C10 now show darker borders and they print as well with nothing needing to be in any cell.

This is also displayed correctly at Edit > Page Preview. AOO4.0.1 under Windows
Back to top
View user's profile Send private message
leftler
Newbie
Newbie


Joined: 25 Oct 2013
Posts: 1

PostPosted: Fri Oct 25, 2013 1:28 pm    Post subject: Reply with quote

JohnV wrote:
I selected the empty range A1:C10 ...


I can re-create the problem by selecting the range A:C, when you apply the formatting to the full column it will only show the borders up to the last line that has text

Just one line of text


Two lines of text


Text in the 2nd column
[/img]
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group