jspreadsheet / ce

Jspreadsheet is a lightweight vanilla javascript plugin to create amazing web-based interactive tables and spreadsheets compatible with other spreadsheet software.
https://bossanova.uk/jspreadsheet/v4
MIT License
6.66k stars 818 forks source link

Is there a way to jump to a particular row number? #1688

Closed asirota closed 1 month ago

asirota commented 1 month ago

Is there a way to jump to a certain row number via javascript? If given a row number can the spreadsheet be called to navigate to that row automatically?

hodeware commented 1 month ago

On the CE, you can navigate to a specific page (not a row). If you are using lazy loading, you can call instance.loadPage or instance.page if you are using pagination. There is also an option instance.goto(y, x) that can navigate to any cell on the spreadsheet, but this is only available in the Pro version.