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 stop creating/printing pie charts?

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


Joined: 04 Mar 2006
Posts: 6

PostPosted: Sat Mar 04, 2006 8:55 am    Post subject: How to stop creating/printing pie charts? Reply with quote

When I print a spreadsheet, it also prints several pie charts. How do I turn off the feature that is creating these pie charts? Using OpenOffice.org 2.0
Back to top
View user's profile Send private message
gpl_racer
Power User
Power User


Joined: 08 Sep 2005
Posts: 83
Location: Finland

PostPosted: Sat Mar 04, 2006 9:08 am    Post subject: Reply with quote

Do you mean you want to print everything else but the charts...? If so, then Format -> Page... -> Spreadsheet -> uncheck Charts ...
Back to top
View user's profile Send private message
rekees
General User
General User


Joined: 04 Mar 2006
Posts: 6

PostPosted: Sat Mar 04, 2006 2:05 pm    Post subject: Reply with quote

>>Do you mean you want to print everything else but the charts...? If so, then Format -> Page... -> Spreadsheet -> uncheck Charts ...<<

I just want to print the columns and rows. I have no idea where the pie charts are coming from. I do not see them in the spreadsheet. I assume there is some feature in OpenOffice Calc that is automatically generating them? I tried your "uncheck Charts" suggestion and it didn't work.
Back to top
View user's profile Send private message
gpl_racer
Power User
Power User


Joined: 08 Sep 2005
Posts: 83
Location: Finland

PostPosted: Sat Mar 04, 2006 2:16 pm    Post subject: Reply with quote

Thatīs strange...

Only thing that comes to my mind right now is: Tools -> Preferences... -> OpenOffice.org Calc -> Show -> check that Charts is not set to Hidden...
Are the charts visible in print preview...?
Back to top
View user's profile Send private message
rekees
General User
General User


Joined: 04 Mar 2006
Posts: 6

PostPosted: Sat Mar 04, 2006 2:23 pm    Post subject: Reply with quote

>>Only thing that comes to my mind right now is: Tools -> Preferences... -> OpenOffice.org Calc -> Show -> check that Charts is not set to Hidden...<<
Under the Tools menu, Preferences is not listed.

>>Are the charts visible in print preview...?<<
Yes
Back to top
View user's profile Send private message
gpl_racer
Power User
Power User


Joined: 08 Sep 2005
Posts: 83
Location: Finland

PostPosted: Sun Mar 05, 2006 1:45 am    Post subject: Reply with quote

Sorry, it must be Tools -> Settings then (my OO is in Finnish)...

Because the charts are visible in print preview it suggests that the charts are there but they are hidden...
Back to top
View user's profile Send private message
rekees
General User
General User


Joined: 04 Mar 2006
Posts: 6

PostPosted: Sun Mar 05, 2006 5:17 am    Post subject: Reply with quote

>>Sorry, it must be Tools -> Settings<<
Tools -> Options -> OpenOffice.org Calc -> View -> Objects section -> Charts is set to Show

>>Because the charts are visible in print preview it suggests that the charts are there but they are hidden...<<
The charts are visible in print preview but they are not visible in the spreadsheet so they are either classified as "hidden" or being created by a feature/bug in OpenOffice 2.0.
Back to top
View user's profile Send private message
gpl_racer
Power User
Power User


Joined: 08 Sep 2005
Posts: 83
Location: Finland

PostPosted: Sun Mar 05, 2006 5:32 am    Post subject: Reply with quote

Now I really donīt have a clue what could cause that...

Do you have an example of a spreadsheet, where this is happening, that you could send me so that I can see it myself...? If you do, I can give you my e-mail address...
Back to top
View user's profile Send private message
rekees
General User
General User


Joined: 04 Mar 2006
Posts: 6

PostPosted: Sun Mar 05, 2006 6:03 am    Post subject: Reply with quote

The spreadsheet contains personal information so I decline to share it. Nevertheless thank you for your offer to help me. I can work around the problem by using the Page Range feature when printing occurs so I will take that approach.
Back to top
View user's profile Send private message
gpl_racer
Power User
Power User


Joined: 08 Sep 2005
Posts: 83
Location: Finland

PostPosted: Sun Mar 05, 2006 6:32 am    Post subject: Reply with quote

Ok, I understand...

By the way, does this happen with all your spreadsheets or is it just in certain spreadsheet(s)...? For example if you create a new empty spreadsheet and then fill it with numbers etc., do the charts appear then too...?
Back to top
View user's profile Send private message
rekees
General User
General User


Joined: 04 Mar 2006
Posts: 6

PostPosted: Sun Mar 05, 2006 8:34 am    Post subject: Reply with quote

>>By the way, does this happen with all your spreadsheets or is it just in certain spreadsheet(s)...?<<
Just certain spreadsheets that have similar in content. The file format is .xls and when I read the file(s) using Excel the pie charts do not appear in the print preview. In my opinion there is a bug in OpenOffice but it is not a major problem. The only reason I posted on this forum was because I was hoping somebody else had encountered this bug.

>> For example if you create a new empty spreadsheet and then fill it with numbers etc., do the charts appear then too...?<<
No

Thanks again for your help. Smile
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