How to suppress spreadsheet control validation popup

[Jocelyn]

Hi

We have implemented the max length validation on cells in spreadsheet control following below link. It works as it stated in the demo. We have 2 questions related to that.

1. Can we suppress the validation popup when user enters more than specified characters? It's not intuitive without the popup but it will work with my 2nd question.

2. Can we stop user from typing more than specified characters in a cell?

https://demos.telerik.com/aspnet-mvc/spreadsheet/validation

Thanks. 

Jocelyn

 

[Anton Mironov]

Hello Jocelyn,

Thank you for the details provided. I can clearly see your point.

Unfortunately, the Kendo UI Spreadsheet works similarly to MS Excel. The data validations are set with the pointed pop-up.

Attached is a sample Excel file, that represents the pointed behavior. The A1 cell has its validation rule(length < 3).

If you try to input more than 2 characters in the A1 cell, Excel will give you the opportunity to do it. But when closing the cell, the validation will execute and the popup with the validation error appears.

I hope this information helps. Let me know if I could assist further.

Kind Regards,
Anton Mironov
Progress Telerik