Issue 5359

Summary: Xcl Imp/Exp: unsupported chart features
Product: Calc Reporter: Unknown <non-migrated>
Component: codeAssignee: AOO issues mailing list <issues>
Status: ACCEPTED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 1.0.0   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Description Flags
xls spreadsheet with charts none

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
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 
The chart engine will be completely reimpemented soon. I can fix 
most of the problems only with this new chart.

Reminder: All problems 

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 

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.