Scroll to a cell

[Majid Razmjoo]

Is there a way to scroll to a cell in spreadsheet? The use case is that we want to focus a specific cell of the spreadsheet on an external event.

[Sangeetha Priya Murugan]

Hi Majid,

Your requirement can be achievable by using goTo method as like as below.

Code Block:

 

 function navigateCell() {

    spreadsheet.goTo('B100:B105'); // pass the range to navigate the cell

  }

 

For your convenience, we have prepared the sample based on our suggestion in a button click event. Please find the link below.

Sample Link: https://stackblitz.com/edit/react-vkcq3e?file=index.js

API Link: https://ej2.syncfusion.com/react/documentation/api/spreadsheet/#goto