Re: [libreoffice-users] CSV import trouble (numbers & locale)

Howdy,

Well, I'm using LibreOffice 6.2.3 (with Ubuntu) and have created a csv file
with two data rows
12.12
12.123

Then set my global locale to Italian(Italy) and try to open the csv file.
(which is using a tab to separate values btw)
If in the dialog box I change the defaulted Italian(Italy) locale to
English(USA) everything works as expected, with the data in the now
Italian(Italy) local file:
12,12
12,123

If I do not set the locale in the import dialog to a locale which used the
'.' for decimal it does not work properly.

But if doing it in that order does is not working on the MAC then I would
say yes you should open an issue in the bug tracker.

Best wishes,

drew



On Tue, Apr 23, 2019 at 11:08 PM Andrea Venturoli <ml@netfence.it> wrote:

> On 4/23/19 10:39 PM, Italo Vignoli wrote:
> > IMHO the issue could be related to the cell format, either to the number
> > of decimals or to the thousands separator. In any case, the cell format
> > can be tweaked.
>
> Thanks for your answer.
> However I'm not sure what you mean here:
>
> _ tweaking on the CSV side? Sure I can, but I'd rather not: the file has
> other uses, besides being importe in LibreOffice; also it's already
> correct (for some definition of correct, i.e. English locale);
>
> _ tweaking during import? I don't see any option to choose decimal
> separator; only locale setting, which, as I said, does not work.
>
> _ settings decimal separator globally? This is not what my customer
> wants: she wants to work with Italian locale, but be able to import this
> single file with dot as decimal separator; the option seems to be there,
> just not working.
>
> _ Something else? What?
>
>
>
>
> What I'm trying to understand is whether the fact that setting locale in
> the import dialog has no effect is a bug (which I should report) or if
> I'm just trying something that will never work conveniently and I'll
> need to think about a different workflow.
>
>   bye & Thanks
>         av.
>
> --
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy