Data Validation

2 posts, 1 answers
  1. John
    John avatar
    21 posts
    Member since:
    May 2015

    Posted 23 Dec 2015 Link to this post

    I have been trying to add Data Validation to a cell. I have chosen "List" as my validation type, but I have not been able to figure out how I should enter the list in the text box to get it to work.

     I have tried the following:

    New, Deleted, Existing

    'New', 'Deleted', 'Existing'

    ['New', 'Deleted', 'Existing']

    What is the correct format to use for the List option in Data Validation?

  2. Answer
    Alex Gyoshev
    Alex Gyoshev avatar
    2513 posts

    Posted 24 Dec 2015 Link to this post

    Hello John,

    As shown in the data validation example (last column), the list values need to be a range in the spreadsheet, which contains the listed values. Search for "ListValues" in the source code.

    Alex Gyoshev
    Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
Back to Top