Date imported with cellDates set to true is off by a fraction of a second #2910

New Issue

dominic-simplan · 2023-04-06T15:02:17Z

dominic-simplan commented

2023-04-06 15:02:17 +00:00

I am importing an Excel file with a Date cell:

cellDates is set to true:

XLSX.read(data, {type: 'array', cellDates: true})

Accessing the cells value contains an incorrect Date object which is off by a fraction of a second:

let cell = workbook.Sheets[sheetName]["A2"];
cell.v is "2023-01-30T20:59:59.999Z" while it should be "2023-01-30T21:00:00.000Z"

Please find attached the used Excel file and the HTML example used to reporduce the issue

I am importing an Excel file with a Date cell: ![grafik](/attachments/d7d7d67e-bcb0-4b0f-929b-384aa6a4d17d) cellDates is set to true: `XLSX.read(data, {type: 'array', cellDates: true})` Accessing the cells value contains an incorrect Date object which is off by a fraction of a second: `let cell = workbook.Sheets[sheetName]["A2"];` cell.v is "2023-01-30T20:59:59.999Z" while it should be "2023-01-30T21:00:00.000Z" Please find attached the used Excel file and the HTML example used to reporduce the issue

date_new.xlsx

8.3 KiB

sheetjs.zip

3.1 KiB

grafik.png

1.9 KiB

dominic-simplan commented

2023-05-16 12:10:33 +00:00

Is there any workaround for this issue or any hint where to fix this in the source code?
Do you accept Merge Requests?

Is there any workaround for this issue or any hint where to fix this in the source code? Do you accept Merge Requests?

sheetjs commented

2023-06-26 01:41:18 +00:00

This should work correctly in 0.20.0, as verified on the websites https://oss.sheetjs.com/ and https://oss.sheetjs.com/sheetjs/

If you are getting the wrong results on the live website, please share your current IANA timezone (run Intl.DateTimeFormat().resolvedOptions().timeZone in your browser console) and we can take a closer look

This should work correctly in 0.20.0, as verified on the websites https://oss.sheetjs.com/ and https://oss.sheetjs.com/sheetjs/ If you are getting the wrong results on the live website, please share your current IANA timezone (run `Intl.DateTimeFormat().resolvedOptions().timeZone` in your browser console) and we can take a closer look

sheetjs closed this issue

2023-06-26 01:41:19 +00:00

Sign in to join this conversation.