By using “onBeforeValueChange” I try to get old and new values from cell to compare with some dates, but method returns dates in strange format.
Please, take a look at the snippet
https://snippet.webix.com/hzo4j16f
Hello @Mikalai,
By using “onBeforeValueChange” I try to get old and new values from cell to compare with some dates, but method returns dates in strange format.
In fact, the returned value is the date presented in Excel date format. You can use a custom function and convert the Excel date to the standard JS Date object: Code Snippet.