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.