Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Chart data range not remembered after quit | ||||||
---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | philipp.login | ||||
Component: | save-export | Assignee: | AOO issues mailing list <issues> | ||||
Status: | CONFIRMED --- | QA Contact: | |||||
Severity: | Normal | ||||||
Priority: | P3 | CC: | oooforum | ||||
Version: | 4.1.1 | ||||||
Target Milestone: | --- | ||||||
Hardware: | All | ||||||
OS: | Mac OS X, all | ||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||
Developer Difficulty: | --- | ||||||
Attachments: |
|
Confirm with Stock Chart 4 only
Other Stock Charts don't forget the 1st cell
> NB: The problem also occurs for other chart types, such as "Column".
And Bar chart too
|
Created attachment 84130 [details] Sample spreadsheet to reproduce the problem To reproduce: 1. Open the attached spreadsheet 2. Choose Insert > Chart 3. Choose "Stock" as the chart type 4. Choose "Stock Chart 4" as the subtype 5. Click Next 6. Enter the following as the data range: $Sheet1.$A$1:$F$1;$Sheet1.$A$3:$F$5 7. Click Finish 8. Save the document 9. Quit OpenOffice 10. Reopen the spreadsheet 11. Double-click the chart 12. Choose Format > Data Ranges... The data range now shows: $Sheet1.$A$3:$F$5;$Sheet1.$B$1:$F$1 First, the cell $A$1 has been dropped from the range. And second, the order has been changed, which is a problem if you created the original order to make editing easier. NB: The problem also occurs for other chart types, such as "Column".