Spreadsheet Validation at the Column Level?

[xav]

I'm looking at the spreadsheet validation here: https://demos.telerik.com/kendo-ui/spreadsheet/validation
It should that validation rules are set at each individual cell.   We are looking to build this grid dynamically (populating from a database) and that would require iterating through each cell to set validation.  Is there a way to set validation at the column level? 

[Neli]

Hello,

You can use the range validation method and apply validation to multiple cells:

- https://docs.telerik.com/kendo-ui/api/javascript/spreadsheet/range/methods/validation

Here is a Dojo example where the validation is applied to all the cells in column A.

I hope this helps.

Regards,
Neli
Progress Telerik

[brajesh]

Yes this is helping but I need to set validation dynamically because columns comes dynamically.

[Martin]

The validation method is the one you should use to set rules dynamically, as you can use the Range value method to change the cell values dynamically. If you provide a runnable example where I can better understand the scenario, I will be able to provide further guidance.