This is a migrated thread and some comments may be shown as answers.

Column Validation

2 Answers 47 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Wayne Hiller
Top achievements
Rank 1
Veteran
Iron
Wayne Hiller asked on 04 Jan 2016, 05:02 PM
Is there any way (or plans) to do Column Validation? It seems very inefficient to always have to setup the Validation for every cell individually. 

2 Answers, 1 is accepted

Sort by
0
Accepted
Georgi Krustev
Telerik team
answered on 06 Jan 2016, 10:59 AM
Hello Wayne,

The required functionality is already supported. You just need to set the validation to a specific range, which in this case is a whole column. For instance, you can get a range for the current column and set the required validation:
var range = spreadsheet.activeSheet().range("E:E"); //range for the column 'E'
 
range.validation([ validation here ]);

Regards,
Georgi Krustev
Telerik
 
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
 
0
Wayne Hiller
Top achievements
Rank 1
Veteran
Iron
answered on 06 Jan 2016, 02:21 PM

I don't know why I did not see that, thank you.

 

Tags
Spreadsheet
Asked by
Wayne Hiller
Top achievements
Rank 1
Veteran
Iron
Answers by
Georgi Krustev
Telerik team
Wayne Hiller
Top achievements
Rank 1
Veteran
Iron
Share this question
or