Issue 125811

Summary: Chart data range not remembered after quit
Product: Calc Reporter: philipp.login
Component: save-exportAssignee: 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:
Description Flags
Sample spreadsheet to reproduce the problem none

Description philipp.login 2014-10-31 10:07:32 UTC
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".
Comment 1 oooforum (fr) 2014-10-31 14:08:23 UTC
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