3 Answers, 1 is accepted
Yes, the Kendo Spreadsheet offers such functionality. Here you will find the Custom cell editors demo, where a drop-down is configured for the values in the B1 cell. Note, that Cell editor is specified using the cell validation:
Keep in mind, that the Cell editor could be configured per cell, as in the above example, or per range of cells, using the Spreadsheet.Range.validation() method.
By implementing the validation approach in cell the list will be shown, but what if we need to allow the user to enter any other values which are not in list.
So if list has A,B,C option, but user type D in cell it will gives validation issue. Can we allow user to enter anything in list option and cell should not be highlighted as validation. Is that possible Veselin?
You could change the validation type from reject to warning. That would allow the user to type custom input in the cells in question:
The above, however, will still display the validation warning triangle. If you need to avoid that, you should reset the validation configuration upon change. To do that you could use the Spreadsheet change event:
Here is a small sample implementing the above.