Hi, I'm using the spreadsheet control and i'm having an issue with date columns.
When I enter a valid date, it works fine.
but when I enter an empty date (clicking delete on date column, or emptying out the contents)
the date gets stored as "new Date(0,0,-1)" ["Sat Dec 30 1899 00:00:00 GMT+1130 (New Zealand Daylight Time)" in my local time]
obviously, this is incorrect, and it should store the value as NULL.
it happens regardless of whether the schema/model has nullable=true.
If I manually modify the dataItem via JS, it stores it correctly as null.
I have a dojo demo set up which replicates the issue.
https://dojo.telerik.com/oFowivUN
Steps:
Doing some investigation into the kendo code, it seems to be caused by the serialToDate method of the spreadsheet.
Thanks
Hello Stephen,
The observed should be considered a bug in the Sheet DataSource functionality. That is why I have converted the current thread to a bug report in our public Feedback portal:
Apart from that, I have also created a GitHub issue on the same in our public repo:
https://github.com/telerik/kendo-ui-core/issues/6516
Keep tracking the above as they will be updated as soon as we start working on the issue in question.
As a small token of gratitude for reporting this bug, I have updated your Telerik points.
Regards,
Veselin Tsvetanov
Progress Telerik
Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.