Hi Dinesh,
You could change the validation type from
reject to
warning. That would allow the user to type custom input in the cells in question:
The above, however, will still display the validation warning triangle. If you need to avoid that, you should reset the validation configuration upon change. To do that you could use
the Spreadsheet change event:
Here is a small sample implementing the above.
Regards,
Veselin Tsvetanov
Progress Telerik
Get
quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers.
Learn More.