Hi,
We have a requirement, where we have a kendo grid, from the grid columns we need one or multiple columns as a dropdown/combobox.
Along with the above requirement we have the below requirements.
1. Grid column with Dropdown/Combobox should work when paste in grid
2. Export also should work with dropdown/combobox columns.
To add new rows in the grid, we have to copy the rows from excel and paste in the grid, so after the paste all the new records should appear even in the dropdown/combobox field. The export is a client side export.
And for the grid we have a button for exporting the grid data in excel. If for specific column which will be dropdown/combobox which will be of complex type then after export how that column will display in the excel.
Note: We have already tried with dropdownlist in the grid. We created a UI component and user that inside EditorTemplateComponentName
in the cshtml file. We are able to render the dropdown for that particular column inside the grid. But the problem is with dropdownlist column when we try to copy and paste records from excel to grid, paste is not working for dropdown column.
And also the dropdown column is a complex type so when we export the grid, the dropdown column value is not render in the excel file.
So, we are thinking to achieve the above requirements with a combo box, please provide the solution for the above requirements.