Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Wrong chart import from Excel | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | Unknown <non-migrated> | ||||||||
Component: | ui | Assignee: | john.marmion | ||||||||
Status: | CLOSED DUPLICATE | QA Contact: | issues@sc <issues> | ||||||||
Severity: | Trivial | ||||||||||
Priority: | P3 | CC: | issues | ||||||||
Version: | OOo 1.1 RC2 | ||||||||||
Target Milestone: | --- | ||||||||||
Hardware: | PC | ||||||||||
OS: | Windows 2000 | ||||||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||||||
Developer Difficulty: | --- | ||||||||||
Attachments: |
|
Description
Unknown
2003-08-22 10:23:48 UTC
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 |