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 <[email protected]> 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: [email protected] > 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: [email protected] 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
