Bug 90840 - Some decimals are not imported properly by CSV
Summary: Some decimals are not imported properly by CSV
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.7.2 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-04-24 18:01 UTC by eugaia
Modified: 2015-04-24 20:22 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
CSV file with example data that does not import properly (2.27 KB, text/csv)
2015-04-24 18:01 UTC, eugaia
Details

Note You need to log in before you can comment on or make changes to this bug.
Description eugaia 2015-04-24 18:01:00 UTC
Created attachment 115073 [details]
CSV file with example data that does not import properly

Hi,

When importing the CSV data that's attached in the attached file, the value for 'Weight' (which should be 2.833) is imported as 2833, however the value for 'SuggestedPrice' is correctly imported as 16.4900.

I'm using the packaged version on Ubuntu 14.04.

Sorry, I've not tried on more recent versions.

Thanks.
Comment 1 raal 2015-04-24 19:25:31 UTC
Hello,
tested with LO 4.4.2, win7 and Version: 5.0.0.0.alpha1+
Build ID: badec7478035008f514e0976a94438fe2e32dc40
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2015-04-22_01:28:24

and can not confirm. Closing as worksforme. Set again as unconfirmed if you have sittl problem with current version 4.4.x. Version 4.2 is EOL. Thanks
Comment 2 m_a_riosv 2015-04-24 20:22:15 UTC
It's needed to set up properly the options in the import windows.

Selecting in the language a country using dot as decimal point, avoid selects for every column with values as type US English.