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

On Sunday, 20 April 2014, M. Fioretti <mfioretti@nexaima.net> wrote:

> 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: users+unsubscribe@global.libreoffice.org<javascript:;>
> 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

Hi, don't know if this helps but, I have seen the same thing in LO and
other programs too. Zotero, under windows 8.1.1. English (Ireland), where
LO was in English, but the files coming from Italian versons kept the
definitions as they would be Italian instead of Irish (as the locale was
Irish English). For Zotero the program "decided" the locale based on the IP
of the machine (don't know why) and needed an config change. For LO files
from Italian source they needed to be saved as "new name" and the locale
changed.

Could it be that for some reason programs also look at your IP address and
when seeing that it is in X-location (western) assume that your system
locale is based on that IP zone. I have seen that when moving my PC from
Italy to Finland e.g. Why this happens I have no idea.

The above might be a long shoot but since it happens for some programs
might be a worth to check out.

--
Heikki T. Jussila



-- 
--
Heikki Jussila
via Matteotti 6 int. 8
I-56124 Pisa (PI)
ITALIA
--
mobile: +39 335 5352917
skype: heikki.tapio.jussila

-- 
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