Issue 103907

Summary: Loss of Chart Data Range when opening OOo 3.x Calc document with OOo 2.x
Product: Calc Reporter: baumux <baumux>
Component: editingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, michael.haus, rb.henschel
Version: OOo 3.0.1Keywords: oooqa
Target Milestone: ---   
Hardware: PC   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
examlpe none

Description baumux 2009-07-30 15:04:26 UTC
If an OOo 3.x Calc sheet name contains a dot, the chart's data range is lost
when opening the sheet in OOo 2.x and double-clicking the chart

* create a new spreadsheet in OOo 3.x
OOo->Menu "File"->New->Spreadsheet
* insert some data
A1 insert 10
B1 insert 20
C1 insert 30
* select A1, B1 and C1
* create a chart 
Menu "Insert"->Chart...->Chart Type "Column" "Normal"->Button "Finish"
* rename the sheet name
Menu "Format"->Sheet->Rename...->Name->A.1->Button "OK"
* save the Spreadsheet document
OOo->Menu "File"->Save As...->ODF Spreadsheet (.odt)  
* close the Spreadsheet document
OOo->Menu "File"->Close

* open the Spreadsheet document in OOo 2.x as 2.4.2
* double-click the chart

--> The chart's Data Range is lost, irrespective of the selection of ODF 1.0/
1.1, or 1.2 when saving the document using OOo 3.x
Comment 1 baumux 2009-07-30 15:05:03 UTC
Created attachment 63860 [details]
examlpe
Comment 2 chemtech 2009-07-31 17:41:12 UTC
Confirm
If opening is OOo 3.2dev ok.
If opening 2.4.1 - loss of chart data range.
Comment 3 Regina Henschel 2009-07-31 18:18:48 UTC
You should not expect, that OOo2.4.2 can read the file without errors, because a
table name with a dot is not allowed in OOo2.4.2.

The question is, whether OOo3.x should change the table name when exporting in
ODF 1.0/1.1. I'm uncertain about this, because the table name might be used in
functions as string constant or is calculated on some way.

Another solution could be to provide a compatibility check, which will detect
such errors, so that the user can change his document, so that it becomes
compatible to an earlier OOo version.