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?
1 Answer, 1 is accepted
0
Accepted
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.
Regards,Alex Gyoshev
Telerik
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!