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

1 Answer 37 Views
Data Source DropDownList Spreadsheet
Jatin
Top achievements
Rank 1
Jatin asked on 23 Nov 2021, 02:49 PM

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

1 Answer, 1 is accepted

Sort by
0
Neli
Telerik team
answered on 26 Nov 2021, 09:30 AM

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

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

Claudio
Top achievements
Rank 1
commented on 07 Dec 2021, 09:22 AM

this example breaks accessibility, is there an example that maintains it?
Neli
Telerik team
commented on 10 Dec 2021, 08:34 AM

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

Tags
Data Source DropDownList Spreadsheet
Asked by
Jatin
Top achievements
Rank 1
Answers by
Neli
Telerik team
Share this question
or