Apache OpenOffice (AOO) Bugzilla – Issue 64668
Error using charts with multiple data series
Last modified: 2013-02-24 21:22:03 UTC
If you select ranges which beging at diferent rows the chart is not correct.
Created attachment 35945 [details] Example with 2 charts which would must be identical. However the first is correct and the second is wrong.
Created attachment 36000 [details] New ideas (each one on a sheat) by Tony
... Sorry the last attachment is not related to this bug ! Can it be erased ? Thanks
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 implementation. 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.
Created attachment 36027 [details] A book that produces diferent charts in Excel and in OpenOffice
@NN: Its maybe a calc issue for the new chart.
changing target
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.
confirmed. on win xp OOo 2.1, office 2003. the 2nd series did not come in the chart
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.
->Thomas, please verify in master and close.
verified
closed