Re: ssconvert assumes that Excel/xlsx dates are in US locale?
Morten Welinder <[email protected]> Sun, 15 May 2022 07:49:13 -0400
| Newsgroups | gmane.comp.gnome.apps.gnumeric |
|---|---|
| Message-ID | <CANv4PNkdRwYEfsNKaJUVhr30ycNvha+ZbmMGBg=gbt+arCeZqg@mail.gmail.com> |
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 https://social.msdn.microsoft.com/Forums/office/en-US/e27aaf16-b900-4654-8210-83c5774a179c/xlsx-numfmtid-predefined-id-14-doesnt-match?forum=oxmlsdk It is not clear what they actually do and the answer may be locale dependent. I'll have to do some research. M.