Issue with spreadsheet Range Selection

2 posts, 0 answers
  1. Akshay
    Akshay avatar
    1 posts
    Member since:
    Mar 2020

    Posted 16 Mar Link to this post

    I have implemented kendo spreadsheet in an angular 8 application and a facing the following issue.
    There is a functionality implemented where user can navigate to a particular cell or range of cells selected. I am using the following to do the same.
    this.spreadsheet.activeSheet().range(3,2,1,1).select();



    it works fine when i pass in 1 as row and column count i.e the 3rd and 4th parameter but if i scroll down a bit so that the data is out of view and select a cell and then try to navigate and select a range of cells with
    this.spreadsheet.activeSheet().range(3,2,3,3).select();



    It gives me the following error in the console and the navigation stops working.


    core.js:6014 ERROR TypeError: e.toRangeRef is not a function<br>
        at init.activeCell (kendo.all.min.js:sourcemap:98)<br>
        at init.select (kendo.all.min.js:sourcemap:98)<br>
        at init.select (kendo.all.min.js:sourcemap:98)<br>
        at init.select (kendo.all.min.js:sourcemap:97)<br>
        at SafeSubscriber._next (prgx-lib.js:9946)<br>
        at SafeSubscriber.__tryOrUnsub (Subscriber.js:183)<br>
        at SafeSubscriber.next (Subscriber.js:122)<br>
        at Subscriber._next (Subscriber.js:72)<br>
        at Subscriber.next (Subscriber.js:49)<br>
        at Subject.next (Subject.js:39)



    Any idea how to fix this ?
  2. Petar
    Admin
    Petar avatar
    397 posts

    Posted 18 Mar Link to this post

    Hi Akshay,

    The reported behavior has been logged as a bug and its public thread can be followed on this link: https://feedback.telerik.com/kendo-jquery-ui/1458160-spreadsheet-s-range-select-doesn-t-work-if-the-passed-cells-range-is-outside-the-currently-visible-area

    At this point, I cannot say exactly when this bug will be fixed. You can follow the above thread. Once there is a change in the status of the issue you will be notified about it. We cannot provide a workaround for this issue.

    I've updated your Telerik points as a sign of gratitude for reporting the bug. 

    Let me know if you have any other questions related to the current thread. Thank you once again for reporting the issue.

    Regards,
    Petar
    Progress Telerik

    Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Back to Top