Posted 26 January 2020, 3:02 am EST
Hi,
We have a document and the column has the following values:
Target 1
Actual 1
In Compliance? 1
However, the column has a format of “Date” with type “14-Mar”, excel properly shows the listed values above, however, after converting excel to SpreadJS with the JS converter, it is reading the values as dates, which is incorrect, so the values change to:
1-Jan
1-Jan
1-Jan
```.
See a screenshot with the document opened in excel on the left-hand side, and the same doc converted to SpreadJS on the right.
[img]https://gccontent.blob.core.windows.net/forum-uploads/file-551c9fac-83ea-4cf4-994a-4677ac0fa62b.jpg[/img]
Here the sample excel file zipped.
[zip filename="test.xlsx.zip"]https://gccontent.blob.core.windows.net/forum-uploads/file-ff77a839-40b9-42ca-acc3-764c3aaa1d00.zip[/zip]
Is there a way to correct this behavior, please?
Thanks,
David R