This is a migrated thread and some comments may be shown as answers.

Data Validation

1 Answer 141 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
John
Top achievements
Rank 1
John asked on 24 Dec 2015, 12:22 AM

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

Sort by
0
Accepted
Alex Gyoshev
Telerik team
answered on 24 Dec 2015, 01:17 PM

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!
 
Tags
Spreadsheet
Asked by
John
Top achievements
Rank 1
Answers by
Alex Gyoshev
Telerik team
Share this question
or