Add Dropdown List to few columns of Spreadsheet on Remote/DataSource Data

[Jatin]

Hello,

I would like to know if I can add a dropdown list for some cells that users can select instead of plain text.

For example, consider the below demo

https://demos.telerik.com/kendo-ui/spreadsheet/datasource

 

Can we have some fixed dropdown values to UnitPrice and Discontinued columns to the same example?

 

Thanks

[Neli]

Hi Jatin,

I would suggest taking a look at the Custom Cell editor documentation and demo linked below:

- https://docs.telerik.com/kendo-ui/controls/data-management/spreadsheet/custom-editors

- https://demos.telerik.com/kendo-ui/spreadsheet/custom-editors

In the Dojo example linked here, а DropDownList is configured as a custom editor. 

I hope the provided information will be helpful in resolving the issue.

Regards,
Neli
Progress Telerik

[Claudio]

this example breaks accessibility, is there an example that maintains it?

[Neli]

Hi Claudio, 

Currently, the Spreadsheet does not cover the accessibility standards as is described in the Accessibility article linked here.

However, I would suggest you remove the filter from the DropDownList custom editor. You could also add the 'aria-label="select"' to the element from which the DropDownList is initialized. 

I hope this helps.

Regard,

Neli