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

2019-05-07 Thread Andrea Venturoli
On 2019-04-24 05:43, Drew Jensen wrote: 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. I'm writing just to report the status, after some test: _ on a Mac with 6.2.0 I had no problem; _ on another Mac with 6.2.1 I

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

2019-04-24 Thread Luuk
On 24-4-2019 05:43, Drew Jensen wrote: 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

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

2019-04-23 Thread Drew Jensen
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)

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

2019-04-23 Thread Andrea Venturoli
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

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

2019-04-23 Thread Italo Vignoli
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. On 23/04/19 17:06, Andrea Venturoli wrote: > Hello. > > I'm producing a CSV for a customer of mine, which will import it with >

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

2019-04-23 Thread Andrea Venturoli
Hello. I'm producing a CSV for a customer of mine, which will import it with LibreOffice 6.2 on a Mac. If LibreOffice locale (from Options menu item) is set to English, everything is fine; if it's set to Italian there are problems with numbers: _ 123.45 gets correctly read as 123,45 (we use