Linked by Thom Holwerda on Tue 12th Dec 2006 18:35 UTC, submitted by Patrik Buckau
Features, Office "OpenOffice.org 2.1 is recommend for all users, as it represents a significant improvement over all previous versions. Among other things: multiple monitor support for Impress; improved Calc HTML export; enhanced Access support for Base; even more languages; automatic notification of updates."
Thread beginning with comment 191371
To read all comments associated with this story, please click here.
Calc can't insert chart as new sheet.?
by rakamaka on Tue 12th Dec 2006 21:53 UTC
rakamaka
Member since:
2005-08-12

In Excel i can insert chart as new sheet. But not in calc. It inserts on same worksheet. This prevents me from clear view, editing and printing.

Also import/export between gnumeric, calc and excel and preserving whole format is another topic of discussion. I am talking about just 100 datapoints and simple linear graph..

So still I cannot send OO files back and forth for corrections/editing between my linux distro and my Boss' XP. even in ODF or whatever format it looses format in each transit.

Reply Score: 3

eMagius Member since:
2005-07-06

I've noticed much the same. I'm not sure if these are simple bugs or [bad] design decisions.

(Why was the parent post modded down? It's very much on-topic, not spam, and not a personal attack.)

Reply Parent Score: 3

unoengborg Member since:
2005-07-06

Is this some kind of windows problem? Inserting charts in a new sheet works both in 2.1 and in previous versions. At first I was thinking the grand parent was just trolling (No, it wasn't me that modded him down)

Just select Insert->Chart... and then select "-- new sheet --" from the popdown menu. and then continue to select diagram types etc.

Voila! You have your graphics in a separate sheet.

By specifying the range manually you can even have your graphics in an entirely different spreadsheet document, either from your own computer or a document on the internet.

My guess is that many of the problems that MS-Office users experience when they say that OOo, lacks the features they need just is a matter of being unfamiliar with a new environment.

Not wanting to learn how to do something in a new way is of course a totally valid reason for not switching to another program. I understand that doing so may cost time and money, but it is not the fault of that other program.

Edited 2006-12-13 09:05

Reply Parent Score: 2

marcusgreen Member since:
2006-08-21

I just selected some data, clicked on the graph icon, selected a different sheet and inserted the graph in that other sheet. The graph was drawn in the other sheet. Would that meet your requirements?

Reply Parent Score: 1