-
-
Notifications
You must be signed in to change notification settings - Fork 8k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Date format 14 should have yyyy to correspond with modern Excel #2572
Comments
Fix:
|
Here is documentation on this. Note there are other related issues mentioned here too: https://docs.microsoft.com/en-us/openspecs/office_standards/ms-oe376/0e59abdb-7f4e-48fc-9b89-67832fa11789 Addl Changes:
|
Here is an updated implied.json. Note that I use dateNF="m/d/yy" so I didn't change those entries: [ [123456789000, [ [12345678900, [ [1234567890, [ [123456789, [ [12345678.9, [ [1234567.89, [ [123456.789, [ [12345.6789, [ [1234.56789, [ [123.456789, [ [12.3456789, [ [1.23456789, [ [0.123456789, [ [0.0123456789, [ [0.00123456789, [ [0.000123456789, [ [0.0000123456789, [ [0.00000123456789, [ [0.000000123456789, [ [0.0000000123456789, [ [0.00000000123456789, [ [0.000000000123456789, [ [-12345.6789, [ [11.666666666666666, 0, "11.66666667"], |
What are your computer regional settings? On a mac set to New York, NY, USA, I generated the following file: fmt14.xlsx
The format is using code 14: |
The default format for dates in Excel 2010 and newer includes a 4-digit year. So SSF.format(14, new Date(2017, 1, 19)) (or using 'General' format) should be "2/19/2017", not "2/19/17".
The text was updated successfully, but these errors were encountered: