Column Validation

[Wayne Hiller]

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. 

[Georgi Krustev]

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

 

 

[Wayne Hiller]

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