Get Range

3 posts, 0 answers
  1. Sebastian
    Sebastian avatar
    4 posts
    Member since:
    May 2015

    Posted 21 Jul 2016 Link to this post



    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. Sebastian
    Sebastian avatar
    4 posts
    Member since:
    May 2015

    Posted 25 Jul 2016 in reply to Sebastian Link to this post

    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?

  3. Alex Gyoshev
    Alex Gyoshev avatar
    2527 posts

    Posted 25 Jul 2016 Link to this post

    Hello Sebastian,

    1. Use the selection method.
    2. 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.
    3. 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
    Get started with Kendo UI in days. Online training courses help you quickly implement components into your apps.
Back to Top