spreadsheet_decoder icon indicating copy to clipboard operation
spreadsheet_decoder copied to clipboard
verified publisher icon sestegra

DateTime field wrong timezone.

Open Mmisiek opened this issue 3 years ago • 2 comments

Hi, Thanks for a great plugin! I am loading excel with date/time fields, and I noticed that they are one hour later than they should. Like the wrong timezone is decoded. How it is possible ? Date value in the cell: 5/5/2021 6:38:00 AM is decoded in futter as:2021-05-05T07:38:00.000

Mmisiek avatar Sep 23 '22 22:09 Mmisiek

Currently, the package only supports native date/time formats. If you don't use a custom format for date and time, the package will be able to parse them.

As a workaround, select cells with date and format as a date instead of a custom.

See https://github.com/sestegra/spreadsheet_decoder#features-not-yet-supported

sestegra avatar Sep 24 '22 10:09 sestegra

Duplicate #37

sestegra avatar Sep 24 '22 10:09 sestegra