Posted 26 August 2024, 6:17 am EST
Hi,
This behavior is expected, and there isn’t an event specifically for validating the date from the built-in date time picker before it’s set in a cell.
However, you can use a third-party library for your use case and create a Custom Cell Type to display a custom Date Picker.
For example, please refer to the attached sample where I’ve created a custom cell type and integrated the jQuery DateRange Picker. With this approach, you can validate the date before setting the value, and the EditEnding event will also function as expected.
Sample: Sample.zip
You can check out the following demo on Custom Cell Types: https://www.grapecity.com/spreadjs/demos/features/cells/cell-types/custom/purejs
For more details on the Third Party DateRangePicker, you can refer to the following documentation: https://www.daterangepicker.com/
Regards,
Priyam