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

Printing a spreadsheet

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


Joined: 14 May 2012
Posts: 3

PostPosted: Mon May 14, 2012 7:51 am    Post subject: Printing a spreadsheet Reply with quote

HI
I am trying to print a 6 page spreadsheet. When I check the print preveiw I am only seeing the enteries in columns A<B<C. I printed it off and thats all that was printed. Mad
I have checked out the help pages but still cant sort it out.
Can anyone help.
Thanks tc4266
Back to top
View user's profile Send private message
UmTheMuse
General User
General User


Joined: 05 Apr 2012
Posts: 33
Location: United States

PostPosted: Mon May 14, 2012 8:51 am    Post subject: Reply with quote

In the print dialog (the box that you get when you hit cntrl+p or choose File->Print...), hit the general tab (it's the first one). They give you the option to choose to print all sheets, the selected sheets, or only selected cells. Choose the first option.
Back to top
View user's profile Send private message
tc4266
Newbie
Newbie


Joined: 14 May 2012
Posts: 3

PostPosted: Mon May 14, 2012 9:17 am    Post subject: Reply with quote

Thanks for getting back.
Unfortunatley this does not solve my problem.
I have enteries from 1 to 152.
And from A to E.
When I try to print I am only printing A to C. D to E is blank.
Hope this helps.
Back to top
View user's profile Send private message
jrkrideau
Super User
Super User


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

PostPosted: Mon May 14, 2012 10:21 am    Post subject: Reply with quote

tc4266 wrote:
Thanks for getting back.
Unfortunatley this does not solve my problem.
I have enteries from 1 to 152.
And from A to E.
When I try to print I am only printing A to C. D to E is blank.
Hope this helps.


Have a look at Format > Print Ranges.

Or have a look at View > Page Break Preview to get an idea of what OOo thinks it should be printing.
_________________
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
Jars28
General User
General User


Joined: 24 May 2012
Posts: 10

PostPosted: Fri May 25, 2012 10:05 am    Post subject: Reply with quote

If there's not a defined print range, it may be that the cells are set to "hide when printing" select them and right click>Format Cells...>Cell Protection Tab. If the "Hide when printing" check box is a dash or a check, click on it until it is empty and apply.
_________________
Jared
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