This is a migrated thread and some comments may be shown as answers.

Issue with spreadsheet Range Selection

1 Answer 202 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Akshay
Top achievements
Rank 1
Akshay asked on 16 Mar 2020, 08:20 AM
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 ?

1 Answer, 1 is accepted

Sort by
0
Petar
Telerik team
answered on 18 Mar 2020, 08:13 AM

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.
Tags
Spreadsheet
Asked by
Akshay
Top achievements
Rank 1
Answers by
Petar
Telerik team
Share this question
or