About ko-kr FormatCode incorrect Issue #200

New Issue

2015-04-07T11:15:01Z

JohnJeong123 commented

2015-04-07 11:15:01 +00:00

(Migrated from github.com)

I'm a korean developer.

I am using xlsjs(v0.7.5).

I expected the correct formatcode about ("yyyy-mm-dd") date Format.

But always rendered data is mm/dd/yy that is formatcode 14...

In . ECMA-376

ko-kr "yyyy-mm-dd" formatcode is 34, 35, 52, 53, 55, 56

I want to get correct formatcode about "yyyy-mm-dd" ko-kr date Format.

Is there I missing step on locale setting at sheetjs??

I'm waiting your Response

I'm a korean developer. I am using xlsjs(v0.7.5). I expected the correct formatcode about ("yyyy-mm-dd") date Format. But always rendered data is mm/dd/yy that is formatcode 14... In . ECMA-376 ko-kr "yyyy-mm-dd" formatcode is 34, 35, 52, 53, 55, 56 I want to get correct formatcode about "yyyy-mm-dd" ko-kr date Format. Is there I missing step on locale setting at sheetjs?? I'm waiting your Response

SheetJSDev commented

2015-04-07 14:35:27 +00:00

(Migrated from github.com)

This is the same problem encountered in https://github.com/SheetJS/js-xlsx/issues/181 -- basically, a few excel date formats are locale-specific. You can see the difference if you change your system locale (in the Regional settings) and then open the file in Excel.

Right now, the formatter assumes the locale is en-US. A temporary workaround is described in https://github.com/SheetJS/js-xlsx/issues/181#issuecomment-76733831 until we have a better solution.

This is the same problem encountered in https://github.com/SheetJS/js-xlsx/issues/181 -- basically, a few excel date formats are locale-specific. You can see the difference if you change your system locale (in the Regional settings) and then open the file in Excel. Right now, the formatter assumes the locale is en-US. A temporary workaround is described in https://github.com/SheetJS/js-xlsx/issues/181#issuecomment-76733831 until we have a better solution.

SheetJSDev commented

2017-04-30 16:04:43 +00:00

(Migrated from github.com)

We are pushing a change in 0.9.13 that allows you to specify a dateNF option to the parser to override the date format. It will correctly write a file with the original format, but the JS API will use the specified format instead.

We are pushing a change in 0.9.13 that allows you to specify a `dateNF` option to the parser to override the date format. It will correctly write a file with the original format, but the JS API will use the specified format instead.

Sign in to join this conversation.