On Sat, Apr 19, 2014 23:44:20 PM -0700, Owen Genat wrote:
> M. Fioretti wrote
> > Summarizing, it seems I need some efficient way to tell Calc, when it
> > opens that file, that all the cells of a certain column, except the
> > header, are NUMBERS, not text, in the -1234.12 format.
>
> What Mirosław Zalewski has suggested upthread is essentially correct. The
> data formats must match the language used (usually the locale) on import.
> The solutions are to either: (a) edit the data to contain data formats used
> in the expected language; (b) change the expected language on the Text
> Import dialogue to match the used data formats. For a numeric format of
> -100.25 try selecting a Language of "English (US)" or equivalent on the Text
> Import dialog.
as I wrote in the email you replied to, this is exactly what I have been
doing so far. And it doesn't work, or isn't enough.
Marco
--
M. Fioretti http://mfioretti.com http://stop.zona-m.net
Your own civil rights and the quality of your life heavily depend on how
software is used *around* you
--
To unsubscribe e-mail to: [email protected]
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
