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
answered on 06 Jan 2016, 10:59 AM
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 ]);
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!