Dnia 2014-04-19, o godz. 20:05:40 "M. Fioretti" <mfiore...@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+unsubscr...@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