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

Imported Excel 2000 Tabbed Worksheet Printing Problems

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


Joined: 01 Sep 2004
Posts: 4
Location: Canada

PostPosted: Wed Sep 01, 2004 8:20 pm    Post subject: Imported Excel 2000 Tabbed Worksheet Printing Problems Reply with quote

We are just converting over to Oo.

On Excel 2000 files that have multiple tabbed worksheets and opening them in Oo we can't seem to select and print any other worksheet than the original first worksheet.

Tried saving as an calc file and then try to print...but that does not seem to work.

Anyone have a fix for this?
Back to top
View user's profile Send private message
richhill
OOo Advocate
OOo Advocate


Joined: 16 Jun 2004
Posts: 418
Location: Mesa, AZ

PostPosted: Wed Sep 01, 2004 8:51 pm    Post subject: Reply with quote

Take a look at Format -> Print Ranges -> Edit

I vaguely remember someone mentioning this before (perhaps it is a FAQ)
_________________
OOo Calc tips: http://www.openofficetips.com


Last edited by richhill on Sun Sep 12, 2004 7:39 pm; edited 1 time in total
Back to top
View user's profile Send private message Visit poster's website
bkunkel
Newbie
Newbie


Joined: 01 Sep 2004
Posts: 4
Location: Canada

PostPosted: Wed Sep 01, 2004 9:06 pm    Post subject: Reply with quote

Thanks,

You are correct...on both counts, there was some discussion on this subject under "print preview shows wrong tabs" and the solution is as you suggest.

Tried it and by defining the print area in each worksheet the both are able to be previewed and printed.

Thanks for the reply.

Regards,

bk
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