Under Review
Last Updated: 14 Feb 2024 11:20 by ADMIN
Created on: 07 Feb 2024 16:11
Category: Spreadsheet
Type: Feature Request
spreadsheet editors - more intuitive

Once I showed this control to a few people they loved it and are asking me to make a lot of interfaces with it.
All of these are databound. 
They want some validation, like dropdown lists, datapicker, etc. And I found you can put controls in cells.
But what do I do with hundreds of rows? In the rows/cells there is validation and editors that can be setup.
For databound sheets, the columns would be a more logical place for validation and editors.

I did find this today, prepping for this request,  https://docs.telerik.com/kendo-ui/controls/spreadsheet/custom-editors

But that is not intuitive.

I'd like for the same validation and editors that are available on rows.cells to be available at sheets.columns when the sheets.dataSource is used.

These would be applied to the columns on the data rows created from the datasource.


1 comment
Posted on: 14 Feb 2024 11:20

Hi Doug,

You can use the sheet.range() method to specify the needed range, and then Range.editor() method to set the editor. Below is an example that demonstrates how you can set the editor for a specific range, based on the length of the loaded data:

 dataBound: function (e) {          
              var sheet = e.sender.activeSheet();               
              sheet.range("B1:B" + (sheet.dataSource.data().length+1) ).editor("dropdownlist");

The approach is demonstrated in the Dojo linked here - https://dojo.telerik.com/@NeliKondova/EsiXugeP.

Please review the provided example and let me know if the suggested approach suits your scenario. 

Looking forward to your reply.

Progress Telerik

Stay tuned by visiting our public roadmap and feedback portal pages! Or perhaps, if you are new to our Kendo family, check out our getting started resources