How to suppress spreadsheet control validation popup

1 Answer 8 Views
Spreadsheet
Jocelyn
Top achievements
Rank 1
Jocelyn asked on 04 Oct 2021, 05:54 PM

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

 

1 Answer, 1 is accepted

Sort by
0
Anton Mironov
Telerik team
answered on 07 Oct 2021, 09:03 AM

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

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.

Tags
Spreadsheet
Asked by
Jocelyn
Top achievements
Rank 1
Answers by
Anton Mironov
Telerik team
Share this question
or