Column Validation

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

    Posted 04 Jan 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
    3706 posts

    Posted 06 Jan 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. Kendo UI is VS 2017 Ready
  4. Wayne Hiller
    Wayne Hiller avatar
    37 posts
    Member since:
    Sep 2005

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

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

     

Back to Top