Bug - Incorrect Date is getting displayed in excel viewer

edited January 22 in Technical questions

Issue -> Upload excel with date field "12/03/2021" [mm/dd/yyyy] in
uploader, after upload previous date is displayed in excel viewer.
Reproducible only in India Timezone, Working fine in EST/US
timezones.

Analysis ->

Debugged sheetToArray method in webix.DataDriver.excel data driver. Seems
issue with cell.v value in cell object.

cell.v = "2020-12-02T18:29:50.000Z"

As per existing logic in datadriver,
ncell =webix.i18n.dateFormatStr(cell.v) which returns 12/02/2021

Below is the cell object for your reference.

cell =
{
"t" : "d",
"v" : "2020-12-02T18:29:50.000Z",
"s" : {
"numFmt" : "d-mmm",
"fill" : {
"patternType" : "solid",
"fgColor" : {
"rgb" : "FFE1EBF7"
},
"bgColor" : {
"indexed" : 64
}
},
"font" : {
"sz" : "10",
"color" : {},
"name" : "Calibri"
},
"border" : {
"left" : {
"style" : "thin",
"color" : {
"rgb" : "FFFFFFFF"
}
},
"right" : {
"style" : "thin",
"color" : {
"rgb" : "FFFFFFFF"
}
},
"top" : {
"style" : "thin",
"color" : {
"rgb" : "FFFFFFFF"
}
},
"bottom" : {
"style" : "thin",
"color" : {
"rgb" : "FFFFFFFF"
}
}
},
"alignment" : {
"vertical" : "center",
"horizontal" : "center",
"wrapText" : "1"
}
},
"w" : "3-Dec"
}

Kindly provide your inputs.

Comments

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion