Read cell which is date type error #392

Closed
opened 2016-04-08 09:02:31 +00:00 by FourLeafClover · 2 comments
FourLeafClover commented 2016-04-08 09:02:31 +00:00 (Migrated from github.com)
In my excel. the type of cell is date.  the value is 2015/12/30. but when i read the excel the value change to 12/30/15, How can i get the value  the same as '2015/12/30'
``` In my excel. the type of cell is date. the value is 2015/12/30. but when i read the excel the value change to 12/30/15, How can i get the value the same as '2015/12/30' ```
shikelong commented 2016-09-07 03:00:20 +00:00 (Migrated from github.com)

+1

+1
reviewher commented 2017-01-03 17:47:16 +00:00 (Migrated from github.com)

@FourLeafClover @shikelong What is your current system locale? This is probably a locale issue, the file itself stores the default date in a specific format (mm/dd/yy) but is supposed to read the system locale. Related: #269

@FourLeafClover @shikelong What is your current system locale? This is probably a locale issue, the file itself stores the default date in a specific format (mm/dd/yy) but is supposed to read the system locale. Related: #269
Sign in to join this conversation.
No Milestone
No Assignees
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: sheetjs/sheetjs#392
No description provided.