| View previous topic :: View next topic |
| Author |
Message |
rekees
General User
Joined: 04 Mar 2006
Posts: 6
|
 Posted: Sat Mar 04, 2006 8:55 am Post subject: How to stop creating/printing pie charts? |
 |
|
| 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 |
|
 |
gpl_racer
Power User
Joined: 08 Sep 2005
Posts: 83
Location: Finland
|
| Posted: Sat Mar 04, 2006 9:08 am Post subject: |
|
|
| Do you mean you want to print everything else but the charts...? If so, then Format -> Page... -> Spreadsheet -> uncheck Charts ... |
|
| Back to top |
|
|
rekees
General User
Joined: 04 Mar 2006
Posts: 6
|
| Posted: Sat Mar 04, 2006 2:05 pm Post subject: |
|
|
>>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 |
|
|
gpl_racer
Power User
Joined: 08 Sep 2005
Posts: 83
Location: Finland
|
| Posted: Sat Mar 04, 2006 2:16 pm Post subject: |
|
|
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 |
|
|
rekees
General User
Joined: 04 Mar 2006
Posts: 6
|
| Posted: Sat Mar 04, 2006 2:23 pm Post subject: |
|
|
>>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 |
|
|
gpl_racer
Power User
Joined: 08 Sep 2005
Posts: 83
Location: Finland
|
| Posted: Sun Mar 05, 2006 1:45 am Post subject: |
|
|
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 |
|
|
rekees
General User
Joined: 04 Mar 2006
Posts: 6
|
| Posted: Sun Mar 05, 2006 5:17 am Post subject: |
|
|
>>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 |
|
|
gpl_racer
Power User
Joined: 08 Sep 2005
Posts: 83
Location: Finland
|
| Posted: Sun Mar 05, 2006 5:32 am Post subject: |
|
|
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 |
|
|
rekees
General User
Joined: 04 Mar 2006
Posts: 6
|
| Posted: Sun Mar 05, 2006 6:03 am Post subject: |
|
|
| 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 |
|
|
gpl_racer
Power User
Joined: 08 Sep 2005
Posts: 83
Location: Finland
|
| Posted: Sun Mar 05, 2006 6:32 am Post subject: |
|
|
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 |
|
|
rekees
General User
Joined: 04 Mar 2006
Posts: 6
|
| Posted: Sun Mar 05, 2006 8:34 am Post subject: |
|
|
>>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.  |
|
| Back to top |
|
|
|
