Issue 64668 - Error using charts with multiple data series
Summary: Error using charts with multiple data series
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: kla
QA Contact: issues@graphics
Keywords: ms_interoperability, oooqa, usability
Depends on:
Reported: 2006-04-23 18:37 UTC by jfvelezserrano
Modified: 2013-02-24 21:22 UTC (History)
5 users (show)

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

Example with 2 charts which would must be identical. However the first is correct and the second is wrong. (15.33 KB, application/vnd.oasis.opendocument.spreadsheet)
2006-04-23 18:43 UTC, jfvelezserrano
no flags Details
New ideas (each one on a sheat) by Tony (100.16 KB, application/vnd.sun.xml.calc)
2006-04-25 08:33 UTC, pagalmes.lists
no flags Details
A book that produces diferent charts in Excel and in OpenOffice (14.00 KB, application/
2006-04-25 12:02 UTC, jfvelezserrano
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description jfvelezserrano 2006-04-23 18:37:31 UTC
If you select ranges which beging at diferent rows the chart is not correct.
Comment 1 jfvelezserrano 2006-04-23 18:43:15 UTC
Created attachment 35945 [details]
Example with 2 charts which would must be identical. However the first is correct and the second is wrong.
Comment 2 pagalmes.lists 2006-04-25 08:33:46 UTC
Created attachment 36000 [details]
New ideas (each one on a sheat) by Tony
Comment 3 pagalmes.lists 2006-04-25 08:35:35 UTC
... Sorry the last attachment is not related to this bug !
Can it be erased ? Thanks
Comment 4 bjoern.milcke 2006-04-25 11:01:02 UTC
In the current implementation of chart, there is the limitation that you can
only use one cell-range for data. The range is (interpreted by Calc in some way)
and the split-up data passed to the chart.

In your example it looks obvious to have a different behaviour, but in general
it is impossible to guess what a user might want to have. One solution to solve
this problem would be to offer a more flexible way to assign data to specific
data series. This is handled in issue 3997 and will be part of the new chart

For the current chart implementation we will not change the behaviour. As the
new chart implementation will still offer the splitting-up of a single
cell-range (that may consist of more than one contiguous range), we should still
consider this issue.

Indeed, the chart of "you know who" ;-) would create the same chart for both
given ranges in the example document.

The issue still occurs in the new chart implementation (as the splitting up uses
the same code in the DataProvider than it used before).

->KLA: This is a Calc issue, concerning the method "createDataSource" of the
"XDataProvider" interface.
Comment 5 jfvelezserrano 2006-04-25 12:02:12 UTC
Created attachment 36027 [details]
A book that produces diferent charts in Excel and in OpenOffice
Comment 6 kla 2006-04-26 09:56:50 UTC
@NN: Its maybe a calc issue for the new chart. 
Comment 7 niklas.nebel 2006-07-07 19:03:51 UTC
changing target
Comment 8 mestech 2006-08-16 21:20:01 UTC
Using Milestone 7 on Linux, it is possible to get the correct chart.  It isn't
as easy as it could be but it can be done.  Good start

The second range of values has to be manually entered into the data series dialog.
Comment 9 utomo99 2006-11-19 06:30:45 UTC
confirmed. on win xp OOo 2.1, office 2003. 
the 2nd series did not come in the chart
Comment 10 IngridvdM 2007-08-03 09:48:33 UTC
This bug is fixed with the complete re-implementation of the chart module
starting with version SRC680m213.
Loading the attached Book1.xls now results in a column chart with two dataseries
which have the correct cell ranges.
You can also create such a chart in OOo directly using the new DataSeries
tabpage in the new wizard or in the new Data Ranges dialog. Here you can create
and delete series and select different cell ranges for each series.
Comment 11 IngridvdM 2007-08-03 09:49:44 UTC
->Thomas, please verify in master and close.
Comment 12 kla 2007-08-03 13:04:24 UTC
Comment 13 kla 2007-08-03 13:04:54 UTC