Set initial active cell

[Wayne Hiller]

What is the correct way to set the initial active cell?

sheets: [{
                    selection: "A2:A2",
                    activeCell: "A2"
                }] 

This sets the active cell visually but when I press Tab to move to the next cell I get an error "TypeError: topLeft is undefined"

[Kiril Nikolov]

Hello Wayne Hiller,

 

This seems like a bug that we need to work on. I have logged it in our internal bug tracker so it should be fixed for the next official release.

 

As a small gesture of gratitude I have updated your Telerik Points balance.

Regards,
Kiril Nikolov
Telerik

 

 

[serge]

is still not clear how to correctly set the active cell, in 2021

[Martin]

Hello, Serge,

Here you will find a small example how to set an active cell.

Let me know how that works.

Regards,

Martin

[serge]

is there a way to SET the active cell (vs initialize the grid with an active cell), I tried sheets()[0].activeCell("C11") it throws errors

[serge]

Uncaught TypeError: e.first is not a function at init.activeCell (https://kendo.cdn.telerik.com/2021.1.330/js/kendo.all.min.js:103:18344) at init.activeCell (https://kendo.cdn.telerik.com/2021.1.330/js/kendo.all.min.js:104:1992)

[Martin]

The Sheet class currently does not have an activeCell method to programatically set the activeCell. You can try to change the range and then select it to see if the result would be helpful to you. Here is a small example for reference.