Issue 19791 - Excel chart importing in OO spreadsheet (partly) fails
Summary: Excel chart importing in OO spreadsheet (partly) fails
Status: CLOSED DUPLICATE of issue 15555
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1 RC4
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: john.marmion
QA Contact: issues@sc
URL:
Keywords: ms_interoperability, oooqa
Depends on:
Blocks:
 
Reported: 2003-09-19 09:32 UTC by henkfikkert
Modified: 2003-12-05 17:57 UTC (History)
1 user (show)

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

Attachments
Issue 19791 zipped example XLS files (79.25 KB, application/octet-stream)
2003-09-19 15:13 UTC, henkfikkert 		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 henkfikkert 2003-09-19 09:32:13 UTC 
When I import a more complicated excel chart (2 y-axis chart, surface plot) into
oo, the chart isn't shown correctly. For the 2 y-axis this is solved by e.g
defining the correct axis to use (2nd -right- axis i/o 1st -left- axis and
vice-versa) for the data columns manually.  
A (2D) surface plot translates to a (3D) one. The legend doesn't translate quite
OK. This may also be caused by the scaling of the 3D plot.
Should I also provide an example?
Comment 1 utomo99 2003-09-19 10:15:50 UTC 
Please Attach the documents which make this problem, so we can test it.  

(Without the documents, we cannot confirm the problem easily)
Don't forget to cut other part of the documents, so the file size is
small, but we still able to see the problem.
Comment 2 henkfikkert 2003-09-19 15:13:26 UTC 
Created attachment 9496 [details]
Issue 19791 zipped example XLS files
Comment 3 henkfikkert 2003-09-19 15:26:58 UTC 
The issue19791.zip document contains 2 files:
- energie.xls : the 1st graph does have 2 y axis. The 2 large-value
columns should report to the left side, the small-value columns report
to the right. Seems 1st and 2nd target axis are switched. 
- odf basisblad2.xls: may contain unsupported graphs?
Comment 4 john.marmion 2003-09-19 15:38:30 UTC 
i will look at this
Comment 5 utomo99 2003-09-20 04:07:02 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

energie.xls when opeing on OOo 1.1 Rc4
1. many graph line is missing
2. 2nd graph, date is changed, and also the Y axist is different
range. o, 20, 40 .... 160 changed to 0, 10, 20, ....150

odf basisblad2.xls
take very long time to open, and different graph. I think it is not
yet available in OOo. 
I suggest you create anither issuezilla for this as RFE.
Comment 6 henkfikkert 2003-09-20 15:11:57 UTC 
I will open another issue for the 2nd file as an RFE.
Comment 7 john.marmion 2003-09-22 09:58:01 UTC 
@submitter:Your initial comment that the second chart is an
unsupported type is correct. calc, as yet does not support surface
type charts. But this feature is part of the:

http://graphics.openoffice.org/chart/featurewishes.html

So there is no need to create another issue for this. I am still
looking at the first issue to exhaust any possible workarounds.
Comment 8 john.marmion 2003-09-23 17:33:34 UTC 
The data series order seems to confuse the chart engine. The series
order of columns C,H,I,E rather than C,E,H,I. This explains why the
second chart on the same sheet is much better and very similar to
Excel. This issue appears to be the same as issue 15555. I will close
it as a duplicate.

*** This issue has been marked as a duplicate of 15555 ***
Comment 9 john.marmion 2003-12-05 17:57:43 UTC 
closed