Importing an OpenDocument Spreadsheet file (*.ods) always fails for a few reasons: 1. Copying contents of table(s) always fails; as it's unimplemented, should at least silently succeed 2. Sheet cannot contain column names that cannot be identifiers. Sample document: https://bugs.kde.org/show_bug.cgi?id=309267#attach_74887). To fix this, string-to-identifier routine should be employed as in the rest of Kexi. 3. Sheet should contain unique column names. If a column is duplicated, add _N to it, where N is subsequent integer, increased from 1 until the name become unique. (bugs found while fixing Bug #309267)
Git commit 8251542da9e8d07ed8456efce688a2c02afcaca6 by Jaroslaw Staniek. Committed on 27/06/2014 at 22:01. Pushed by staniek into branch 'master'. Fix crash and import failures for ODS import to Kexi 1. Copying contents of table(s) always fails; as it's unimplemented, now at least silently succeeds. 2. Sheets can now contain column names that cannot be identifiers. Sample document: https://bugs.kde.org/show_bug.cgi?id=309267#attach_74887). 3. Sheet can contain non-unique column names. If a column is duplicated, add _N to it, where N is subsequent integer, increased from 1 until the name become unique. Related: bug 309267 REVIEW:118983 M +53 -19 plugins/kexi/spreadsheet/spreadsheetmigrate.cpp M +4 -1 plugins/kexi/spreadsheet/spreadsheetmigrate.h http://commits.kde.org/calligra/8251542da9e8d07ed8456efce688a2c02afcaca6
Git commit 7f7a2482671e33dd0757784461d231d1228275a2 by Jaroslaw Staniek. Committed on 27/06/2014 at 22:01. Pushed by staniek into branch 'calligra/2.8'. Fix crash and import failures for ODS import to Kexi 1. Copying contents of table(s) always fails; as it's unimplemented, now at least silently succeeds. 2. Sheets can now contain column names that cannot be identifiers. Sample document: https://bugs.kde.org/show_bug.cgi?id=309267#attach_74887). 3. Sheet can contain non-unique column names. If a column is duplicated, add _N to it, where N is subsequent integer, increased from 1 until the name become unique. Related: bug 309267 REVIEW:118983 M +53 -19 plugins/kexi/spreadsheet/spreadsheetmigrate.cpp M +4 -1 plugins/kexi/spreadsheet/spreadsheetmigrate.h http://commits.kde.org/calligra/7f7a2482671e33dd0757784461d231d1228275a2