Hi,
I have some questions about the spreadsheet widget in Kendo:
1. How can I get the currently selected range of cells? The sheet.activeCell method seems just to return the primary selected cell.
2. How can I register an event which triggers if the selection of cells has changed? Currently I use the "render" event, but this triggers more often than I need it to.
3. The "change" event does not trigger, if the undo method is used (which changes some values). How can I trigger the change method including the changed range/values?
Thank you for your help + Best regards
2 Answers, 1 is accepted
Rank 1
Answer to 1.: Ok, I found out myself I can use the "selected" method on the sheet to get a range object for the selected range
Additional open questions: How can I access the dataSource data items for a specific range? If the spreadsheet is reordered, is the dataSource ordering reordered accordingly?
Hello Sebastian,
- Use the selection method.
- I am afraid that there is no suitable event for this at this time. You can continue to use the render event and check if the selection has been changed before performing other operations. You can submit this as a feature request on UserVoice, so that it is considered for implementation in a future release.
- We are aware of this bug, and it is logged for fixing. I am afraid that until it is fixed, we do not have a workaround for it.
Alex Gyoshev
Telerik by Progress