Issue 16778 - MS Excel charts imported badly into OO
Summary: MS Excel charts imported badly into OO
Status: CLOSED DUPLICATE of issue 4040
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC4
Hardware: PC Windows 98
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sw
URL: http://www.shadowlandgames.com/11am%2...
Keywords:
: 16932 (view as issue list)
Depends on:
Blocks:
 
Reported: 2003-07-13 05:21 UTC by sgb
Modified: 2013-08-07 15:13 UTC (History)
1 user (show)

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

Attachments
MS Excel file which exhibits naughty charts (52.00 KB, application/octet-stream)
2003-07-13 05:23 UTC, sgb 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description sgb 2003-07-13 05:21:43 UTC 
MS Excel charts where the label column is not the first seem to be imported
rather badly into OO.  As a case in point, please see the spreadsheet that I'm
going to attach as soon as I've submitted this issue (it's also available
through the associated URL).

The offending charts are on sheet 3, where the first chart only has one line
shown when two should be shown.  The second chart is just completely black, and
seems to be including the column labels as data.  They look quite different in
Excel...
Comment 1 sgb 2003-07-13 05:23:37 UTC 
Created attachment 7623 [details]
MS Excel file which exhibits naughty charts
Comment 2 sgb 2003-07-16 08:14:29 UTC 
Ah, oops.  This is a spreadsheet problem, not a word processor one.  
Reassigning...
Comment 3 oc 2003-07-16 10:53:37 UTC 
*** Issue 16932 has been marked as a duplicate of this issue. ***
Comment 4 sgb 2003-08-11 06:37:24 UTC 
Problem still present in 1.1RC2, so updated the version field.
Comment 5 bulbul 2003-08-11 07:18:56 UTC 
Actually, according to instructions i read posted on another bug, the
version field is just for the version in which the problem was first
detected. So, it should really be set back to its previous value. :-)
Comment 6 utomo99 2003-09-17 10:00:00 UTC 
I can Reproduce the problem on 
OpenOffice 1.1 RC4(default Install, US), Win XP Pro Sp1. 
(And MS Office XP Sp2). 
It is real problem

On sheet 3, the second graph is black only
Comment 7 oc 2003-09-18 15:41:14 UTC 
The main problem is that Excel can handle a much more complex dataarea
as OOo (e.g. it is possible that every series has its own title and
the order of the series and axis is random.) Such a chart could not be
imported correctly in OOo. 
Now the good point: this behaviour will be changed with the new
chartengine, which is currently in build. For more information see:
http://graphics.openoffice.org/chart/chart.html
Issue 4040 has the same reason, so I set this one as duplicate

*** This issue has been marked as a duplicate of 4040 ***
Comment 8 oc 2003-09-18 15:42:45 UTC 
Sorry I mean 4140