Issue 125811 - Chart data range not remembered after quit
Summary: Chart data range not remembered after quit
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: 4.1.1
Hardware: All Mac OS X, all
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-10-31 10:07 UTC by philipp.login
Modified: 2014-10-31 14:08 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Sample spreadsheet to reproduce the problem (11.86 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-10-31 10:07 UTC, philipp.login 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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