Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index

Dnia 2014-04-19, o godz. 20:05:40
"M. Fioretti" <> 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:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.