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

Help with printing a single sheet

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


Joined: 15 Nov 2004
Posts: 4
Location: Harlow, Essex

PostPosted: Mon Nov 15, 2004 3:44 am    Post subject: Help with printing a single sheet Reply with quote

I have recently moved my company away from MS Office and over to OpenOffice, unfortunately one of my users is experiancing a problem with a converted xls file..

The file has 13 sheets, everytime I try to print it will only print sheet 10 & 13 Evil or Very Mad

I have tried the Tools / Options / Spreedsheet / Print > Print Only Selected Sheets route but with no joy, I get nothing at all out of the printer?!?!

Even if I use the File / Print > Print Range > Pages and select, say, sheet 11 I get nothing, it is as if all other sheets are locked from being printed !

Any ideas would be greatfully appreciated...

Regards
Adam

btw.. it works perfectly in Excel !!
Back to top
View user's profile Send private message Visit poster's website
8daysaweek.co.uk
Super User
Super User


Joined: 29 Nov 2003
Posts: 2130
Location: UK

PostPosted: Mon Nov 15, 2004 4:01 am    Post subject: Reply with quote

Hello Adam,

IME this only happens with converted files, why I don't know.

To fix try clicking the square between row numbers and column letters (select all) on the sheets you cannot print, then:

Format > Print Ranges > Define

Previous threads on the same subject:
http://www.oooforum.org/forum/viewtopic.php?t=6248&highlight=print+range
http://www.oooforum.org/forum/viewtopic.php?t=8351&highlight=print+range

HTH Smile,
_________________
James
www.8daysaweek.co.uk - A User-Focused OOo site
Back to top
View user's profile Send private message Visit poster's website AIM Address
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