Column Validation

3 posts, 1 answers
  1. Wayne Hiller
    Wayne Hiller avatar
    40 posts
    Member since:
    Sep 2005

    Posted 04 Jan 2016 Link to this post

    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. Answer
    Georgi Krustev
    Admin
    Georgi Krustev avatar
    3723 posts

    Posted 06 Jan 2016 Link to this post

    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!
     
  3. Wayne Hiller
    Wayne Hiller avatar
    40 posts
    Member since:
    Sep 2005

    Posted 06 Jan 2016 in reply to Georgi Krustev Link to this post

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

     

Back to Top