Menu
when i import following csv file:
test
413.298
it becomes in libre office calc:
test
413298
is that a bug or what is going wrong?
in the import preview it shows correctly, but after import, the comma is gone
test-file: https://dl.dropboxusercontent.com/u/168374/test.csv
873
asked Aug 06 '14 09:08
In LibreOffice Calc, select 'File - Open…' (CTRL + O) and select your CSV file. You will see a 'Text Import' window. You have to set up correct options to open the file.
To move the focus to another cell using the mouse, simply move the mouse pointer to the cell where you want the focus to be and click the left mouse button. Using a cell reference – highlight or delete the existing cell reference in the Name Box on the Formula Bar (Figure 2 on page 8).
Simply select the cells, then right-click, select “Format cells …”, then select “Number” and then select a language from the field that has the desired decimal separator. Save this answer.
In your case, the language setting in the CSV import dialogue is crucial.
Since you've selected german language, LO expects a comma (,) as decimal separator. With german localization, a dot (.) just separates thousands: 100.000,50. Thus, 413298 is the default integer representation for 413.298.
If LO should treat the dot in 413.298 as decimal separator, you'll have to change the language to English (US) in the CSV import dialog. Now, LO will display the value as 413,298, automatically adapting the decimal separator to the overall language settings (Menu "Tools" -> "Options" -> "Language settings") - assuming you're working with an overall language setting to german (as me ;-) ).
190
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
