Re: ssconvert assumes that Excel/xlsx dates are in US locale?
- From: Morten Welinder <mortenw gnome org>
- To: EML <sa212+gnumeric cyconix com>
- Cc: Gnumeric Mailing List <gnumeric-list gnome org>
- Subject: Re: ssconvert assumes that Excel/xlsx dates are in US locale?
- Date: Sun, 15 May 2022 07:49:13 -0400
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.
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]