Issue 2385

Summary: import xy excel charts with series with different x-values
Product: General Reporter: ballelarsen <finn>
Component: chartAssignee: kla <thomas.klarhoefer>
Status: CLOSED FIXED QA Contact: issues@graphics <issues>
Severity: Trivial    
Priority: P2 CC: bjoern.milcke, IngridvdM, issues
Version: 3.3.0 or older (OOo)Keywords: ms_interoperability, rfe_eval_ok, usability
Target Milestone: ---   
Hardware: PC   
OS: Windows 98   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Two "X-akses" in Excel XY-chart. none

Description ballelarsen 2001-12-02 13:00:18 UTC
When trying to convert an Excel workbook with two dataseries in a chart 
Starcalc does not convert the subranged X-aksis from the second series 
correctly. It looks like it uses the row-number for the  second series (when 
having the two datasets in separete sheets). When having the dataseries in the 
same sheet you don't even get a working chart. The following example 
illustrates the problem. Column A and C are the X-aksis and column B and C are 
two series of data. A C are time akses.
A        B      C         D
1	10	2.5	600
2	20	4.5	700
3	30	6.5	800
4	40	8.5	900
5	50		
6	60		
7	70		
8	80		
9	90		
10	100		

The problem occurs when converting an existing XY chart from Excel containing 
the two series with different X-akses. Also I have not found a way to chart the 
series in Starcalc. It seams like the functionallity of using two subsetted X-
akses are missing.
It is used very often to display two data sets from 2 csv-files with 
measurements from independent gauges having an overlap in time (X-aksis).
In Excel you can choose individual X-akses for each data series, I can't find 
this in Starcalc. That, I think, would solve the problem.
Comment 1 ballelarsen 2001-12-02 13:02:36 UTC
Created attachment 745 [details]
Two "X-akses" in Excel XY-chart.
Comment 2 oc 2001-12-03 13:22:55 UTC
This featute is not supported in OO. Maybe something for the new 
chartengine
Comment 3 daniel.rentz 2001-12-03 14:34:44 UTC
Already on the wish list, see 
http://graphics.openoffice.org/chart/featurewishes.html
Comment 4 falko.tesch 2002-01-02 10:35:19 UTC
This issue is re-assigned to Christian Jansen for further evaluation.
Comment 5 christian.jansen 2002-01-02 12:35:42 UTC
Like Daniel wrote, the feature was added to the feature wish list and
has to be discussed.
Comment 6 oc 2002-03-14 14:46:45 UTC
*** Issue 3484 has been marked as a duplicate of this issue. ***
Comment 7 daniel.rentz 2002-05-17 11:35:07 UTC
*** Issue 4582 has been marked as a duplicate of this issue. ***
Comment 8 daniel.rentz 2003-01-15 11:27:25 UTC
*** Issue 10678 has been marked as a duplicate of this issue. ***
Comment 9 christian.jansen 2003-01-30 11:18:45 UTC
Reassigned to Bettina.
Comment 10 frank 2003-10-13 11:11:37 UTC
*** Issue 21112 has been marked as a duplicate of this issue. ***
Comment 11 erwin.tenhumberg 2004-10-28 10:25:35 UTC
enhanced summary, set keywords and reassigned issue according to RFE process
Comment 12 lars 2006-04-25 14:07:50 UTC
*** Issue 64718 has been marked as a duplicate of this issue. ***
Comment 13 pagalmes.lists 2007-03-09 13:03:23 UTC
Isn't that somehow improved with the new chart?
Comment 14 IngridvdM 2007-03-09 13:35:37 UTC
Yes thanks, this is fixed with the new chart in CWS chart2mst3.
The attached file loads correctly now.
The missing feature was addressed with issue 3997.
Comment 15 IngridvdM 2007-03-09 13:38:08 UTC
->Thomas, please verify.
Comment 16 kla 2007-04-03 13:09:04 UTC
verified
Comment 17 tony.galmiche.ooo 2007-06-09 12:38:46 UTC
It's OK for me with m213
-> I close this issue