Bug 96177 - FILEOPEN: When importing an csv, 0.006 reads as 6 in the spreadsheet
Summary: FILEOPEN: When importing an csv, 0.006 reads as 6 in the spreadsheet
Status: CLOSED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.4.6.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-12-01 11:43 UTC by Alex
Modified: 2016-09-03 08:44 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
the csv file (28 bytes, text/csv)
2015-12-01 11:45 UTC, Alex 		Details
screenshot of the wrong result (116.50 KB, image/png)
2015-12-01 11:45 UTC, Alex 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Alex 2015-12-01 11:43:27 UTC 
I attached a tar archive which contains a CSV-File and a screenshot. The CSV-File contains the number 0.006. As you can see in the screenshot, it reads as 6 when I open the file with libreoffice. The screenshot contains libreOffice's "about" dialog, which contains version number and Build-ID.

STEPS TO REPRODUCE:
1. Download and untar the attached archive
2. Open the file test.csv in libreoffice

RESULT:
Cell C2 contains the value 6, as in the screenshot (below the header C3)

EXPECTED RESULT:
Cell C2 contains the value 0.006, as in the CSV file
Comment 1 Alex 2015-12-01 11:45:20 UTC 
Created attachment 120920 [details]
the csv file

The bug tracker does not accept tar archives, so I upload the files individually.
Comment 2 Alex 2015-12-01 11:45:48 UTC 
Created attachment 120921 [details]
screenshot of the wrong result
Comment 3 GerardF 2015-12-01 14:26:35 UTC 
Opens correctly with English US settings.
Opens correctly with French FR settings (numbers imported as text because decimal separator is comma unless I specify English US)

The only case I can get a 6 as result is with a locale which have dot as thousand separator and comma for decimal.
What is your locale, Alex ? German, other ?
Comment 4 Alex 2015-12-01 14:46:57 UTC 
Mh, well, my operating system locale reads as English (United States), but still libreoffice pre-selects German on csv import. 

So, yes, this was the issue.