Issue 5359 - Xcl Imp/Exp: unsupported chart features
Summary: Xcl Imp/Exp: unsupported chart features
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.0
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2002-05-29 08:12 UTC by Unknown
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

xls spreadsheet with charts (67.50 KB, application/octet-stream)
2002-05-29 08:15 UTC, Unknown
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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.