Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Xcl Imp/Exp: unsupported chart features|
|Component:||code||Assignee:||AOO issues mailing list <issues>|
|Status:||ACCEPTED ---||QA Contact:|
|Issue Type:||DEFECT||Latest Confirmation in:||---|
Description Unknown 2002-05-29 08:12:55 UTC
I'm researching to use openoffice instead of microsoft office. Our goal is for heavy users to use microsoft and lite users something else. But it must be compatible with microsoft. When I import an excel spreadsheet with al lot of charts, openoffice imports the spreadsheet not correct. All of the charts are incorrect. Some chart types are changed. By example I have made a bar chart and when imported it's a line chart. All text has changed ... When someone want to spreadsheet I can send it by e-mail. Mark Goedhart firstname.lastname@example.org
Comment 1 Unknown 2002-05-29 08:15:07 UTC
Created attachment 1799 [details] xls spreadsheet with charts
Comment 2 daniel.rentz 2002-05-29 15:06:51 UTC
Well, this document collects a lot of problems of our current chart implementation. The chart engine will be completely reimpemented soon. I can fix most of the problems only with this new chart. Reminder: All problems found Sheet "Bedr. gez." - Legend does not support "hard-coded" series titles, only cell contents can be used. - Chart-only-sheets not supported. Import inserts a chart object into a standard sheet. Sheet "Per bedrijf" - same as above Sheet "% Grafiek" - This kind of combined chart (bars, then lines) not supported yet (left charts), OOo chart only allows that the first series is a line in combined charts - If all data series contain only one value, the import makes one series with all values (right charts)
Comment 3 oc 2002-06-03 12:01:00 UTC
Hi Daniel, you want it, you got it.
Comment 4 daniel.rentz 2002-06-03 12:22:22 UTC
And I take it.
Comment 5 daniel.rentz 2003-01-13 16:32:36 UTC
Comment 6 rafaelda 2005-02-11 05:38:51 UTC
this is an important issue.