Dnia 2014-04-19, o godz. 20:05:40
"M. Fioretti" <firstname.lastname@example.org> 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.
To unsubscribe e-mail to: email@example.com
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
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy