Issue 103907 - Loss of Chart Data Range when opening OOo 3.x Calc document with OOo 2.x
Summary: Loss of Chart Data Range when opening OOo 3.x Calc document with OOo 2.x
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.0.1
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2009-07-30 15:04 UTC by baumux
Modified: 2013-01-29 21:43 UTC (History)
3 users (show)

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


Attachments
examlpe (10.71 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-07-30 15:05 UTC, baumux
no flags Details

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