Re: [libreoffice-users] cannot convert text to number in spreadsheet from csv file

Dnia 2014-04-19, o godz. 20:05:40
"M. Fioretti" <mfioretti@nexaima.net> napisał(a):

> What is happening,

Judging by your name, I suppose you are Italian. I assume that you are
using LibreOffice in your native language, and in Italy, as in most of
Europe, you are using coma as decimal number separator.

And here is answer to your question: your data uses dot as decimal
number separator, but your software expects coma. Since data does not
match expected format, LibreOffice falls back to treating data as text.

> and how can I fix it? 

Select all columns that have misinterpreted, open "Search and Replace"
dialog. Insert dot (.) in "Search" and coma (,) in "Replace".
Make sure that "Only selected" is checked on, but "Regular expression"
is checked off.
Click "Replace all".

> Even better: how to make LO
> automatically format and use strings in the format -1234.12 as numbers
> when it opens the file?

In text file import dialog, you can see preview of data to be imported.
You can click on any column to select it. Then, using "Column type"
drop-down above preview, select "English (USA)". 

You can use the same procedure to tell LibreOffice what format your
dates are, if different from your native one.
-- 
Best regards
Mirosław Zalewski

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted