Apache OpenOffice (AOO) Bugzilla – Issue 18516
Wrong chart import from Excel
Last modified: 2003-09-09 16:00:58 UTC
There are problems importing a chart from an Excel spredsheet: the labels on "x"-axis are wrong, the legend is wrong (and incomplete) and the series displayed are incompleted (is shown only 1 serie of 3). All the rest seems ok! In attachment you will find the Excel file. I'm sorry but the document is very confidential and we had have removed all description strings. The chart is in the last sheet: "Sheet9".
Created attachment 8650 [details] Original Excel file with chart.
I'm investigating and I've discovered this: * if I try to make a chart using data range of numbers: $Sheet2.$E$5:$E$58;$Sheet4.$E$13:$E$66;$Sheet8.$D$2:$D$55 it don't works. The only working versions are using Sheet2 as last range, e.g.: $Sheet4.$E$13:$E$66;$Sheet8.$D$2:$D$55;$Sheet2.$E$5:$E$58 * When I try to add a column label of dates (adding Sheet8.A as first column and selecting the "first column as label" flag), as: $Sheet8.$A$2:$A$55;$Sheet4.$E$13:$E$66;$Sheet8.$D$2:$D$55;$Sheet2.$E$5:$E$58 the chart don't works.
I've reproduced the bug using a new OO's spreadsheet document. It have 4 sheets: Sheet1 and Sheet2 contains two numeric series, Sheet3 contains a serie of dates and Sheet4 try to make the chart using the 2 numeric series as data and the date serie as X-labels: $Sheet3.$A$1:$A$101;$Sheet1.$A$1:$A$101;$Sheet2.$A$1:$A$101 And don't works...I send the file.
Created attachment 8804 [details] An OpenOffice Calc document with wrong chart.
I think to have isolated the problem: the order of ranges data used is not managed by the chart component. The chart component re-order them left-to-right, changing the meaning of columns (you can see this playing with attached examples). Remains the problem that some ranges orders don't works (see previous comments).
Created attachment 8815 [details] Simple spreadsheets with the left-to-right order-problem shown.
I will take a look at this.
accepting
This looks like a similar issue to 15435 and issue 19110. The reason why only one of the data series appears is because there is a rectangular relationship between the Y-axis and the X-axis i.e. E13:E66 and A13:A66. The other problems relate to the intervals of the x-axis not appearing and the data series names not appearing. The data series name workaround is to use a cell content rather than a hrad-coded string. Anyway, these issues should be addressed in the chart module: http://graphics.openoffice.org/chart/chart.html http://graphics.openoffice.org/chart/featurewishes.html I will look to see if there is a workaround to the x-axis interval issue
I looked at the x-axis issue again. So once the data series appear correctly aligned, then the x-axis labels appear correct. I simply put the x-axis in location A1:A12 and the values of subsequent years in B1:B12,C1:C12,D1:D12 and E1:E12. So I will close this as a duplicate of issue 15435. *** This issue has been marked as a duplicate of 15435 ***
mark as closed