Bug 278515

Summary: Importing ODS applies unwanted formating to records containing numbers
Product: [Applications] KEXI Reporter: Dimitrios T Tanis <dimitrios.tanis>
Component: Migration/Import/ExportAssignee: Adam Pigg <adam>
Status: CLOSED FIXED    
Severity: normal CC: staniek
Priority: NOR    
Version: 2.4 alpha3 (Calligra 2.4 alpha3)   
Target Milestone: ---   
Platform: Compiled Sources   
OS: Linux   
Latest Commit: Version Fixed In:
Sentry Crash Report:

Description Dimitrios T Tanis 2011-07-25 23:26:50 UTC 
Version:           2.4 alpha3 (Calligra 2.4 alpha3) (using KDE 4.6.0) 
OS:                Linux

Numbers are formated using a comma as thousands seperator, thus the column cannot be used as an Integer Primary Key

Reproducible: Always

Steps to Reproduce:
Try to import an ODS containing a column with numbers (integers or decimals) above 1000

Actual Results:  
Numbers have thousands seperator appended (eg 1,000)
This results in the data not imported when selecting Integer as Type and defining the column as PK

Expected Results:  
ALL data should be imported exactly as the are in the original file. Formatting could be done with another wizard screen or left totally to the user to do before importing.

The above issue does not happen when importing CSV
Comment 1 Adam Pigg 2011-08-19 19:56:18 UTC 
Git commit dcb60be4034bd8935e74cea5072e85c0fbd2a03b by Adam Pigg.
Committed on 19/08/2011 at 21:52.
Pushed by piggz into branch 'master'.

Return data from a cell as a QVariant instead of the text that is
displayed
BUG:278515

M  +1    -3    kexi/migration/kspread/kspreadmigrate.cpp

http://commits.kde.org/calligra/dcb60be4034bd8935e74cea5072e85c0fbd2a03b