Re: ssconvert assumes that Excel/xlsx dates are in US locale?

2022-05-22 Thread EML
On 22/05/2022 16:40, Morten Welinder wrote: Fixed. The format is locale dependent which, in my book, isn't a great idea. We will now load that file differently in different locales which, evidently, is the Excel way. M. Great; thanks. I see that we work the same days of the week... :)

Re: ssconvert assumes that Excel/xlsx dates are in US locale?

2022-05-22 Thread Morten Welinder
Fixed. The format is locale dependent which, in my book, isn't a great idea. We will now load that file differently in different locales which, evidently, is the Excel way. M. ___ gnumeric-list mailing list gnumeric-list@gnome.org

Re: ssconvert assumes that Excel/xlsx dates are in US locale?

2022-05-15 Thread Morten Welinder
Thanks. In this case you do not have a csv problem, but an xlsx problem. We read the file as per the file format specification and get a cell with m/d/y format. Unfortunately it looks like Excel doesn't follow its own file format! See, for example

Re: ssconvert assumes that Excel/xlsx dates are in US locale?

2022-05-15 Thread EML
On 14/05/2022 22:35, Morten Welinder wrote: The devil's in the details here, so please provide a sample file. And, as always, avoid csv if at all you can. M. Hi Morten - files attached (unless they've been stripped); thanks. This is a 2-cell workbook in English/UK locale, with a date

Re: ssconvert assumes that Excel/xlsx dates are in US locale?

2022-05-14 Thread Morten Welinder
The devil's in the details here, so please provide a sample file. And, as always, avoid csv if at all you can. M. ___ gnumeric-list mailing list gnumeric-list@gnome.org https://mail.gnome.org/mailman/listinfo/gnumeric-list