Libre Office Calc - csv import controls my float
when i import the following csv file:
test
413.298
it becomes in libre office calc:
test
413298
is it a bug or something wrong? in import view it displays correctly but after import the comma is gone
test-file: https://dl.dropboxusercontent.com/u/168374/test.csv
source to share
In your case, the language value in the CSV import dialog is critical .
Since you have selected German, LO expects a comma ( ,
) as a decimal separator. From the German point of localization ( .
) simply separates thousands: 100.000,50
. Thus, it 413298
is the default integer representation for 413.298
.
If LO needs to treat dot in 413.298
as decimal separator, you will need to change the language to English (US)
in the CSV import dialog. LO will now display the value 413,298
, automatically adapting the decimal point to the general language setting (Menu " Tools
" → " Options
" → " Language settings
") - if you are working with the general language setting to German (like me ;-)).
source to share