Apache OpenOffice (AOO) Bugzilla – Issue 103907
Loss of Chart Data Range when opening OOo 3.x Calc document with OOo 2.x
Last modified: 2013-01-29 21:43:01 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
Created attachment 63860 [details] examlpe
Confirm If opening is OOo 3.2dev ok. If opening 2.4.1 - loss of chart data range.
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.