Bug 278515 - Importing ODS applies unwanted formating to records containing numbers
Summary: Importing ODS applies unwanted formating to records containing numbers
Status: CLOSED FIXED
Alias: None
Product: KEXI
Classification: Applications
Component: Migration/Import/Export (show other bugs)
Version: 2.4 alpha3 (Calligra 2.4 alpha3)
Platform: Compiled Sources Linux
: NOR normal
Target Milestone: ---
Assignee: Adam Pigg
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-07-25 23:26 UTC by Dimitrios T Tanis
Modified: 2012-08-11 11:42 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In:


Attachments

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