Jspreadsheet Navigation Methods

Navigation Methods

Jspreadsheet provides a set of methods to programmatically navigate through cells and worksheets within a spreadsheet instance. These methods allow developers to control the active cell or scroll through the grid, enhancing user interaction and automation.

Documentation

The following methods are available for navigating a Jspreadsheet instance. They can be called on a worksheet object to move the active cell or adjust the view.

Methods

Method	Description
`goto(y, x?)`	Moves the active cell to the specified coordinates (y, x).
`pageUp()`	Scrolls the view up by one page, adjusting the visible rows.
`pageDown()`	Scrolls the view down by one page, adjusting the visible rows.
`left()`	Moves the active cell one column to the left.
`up()`	Moves the active cell one row up.
`right()`	Moves the active cell one column to the right.
`down()`	Moves the active cell one row down.
`last()`	Moves the active cell to the last cell in the worksheet.
`first()`	Moves the active cell to the first cell in the worksheet.

Example

Programmatic Navigation in a Spreadsheet

The following example demonstrates how to use Jspreadsheet's navigation methods to control the active cell in a worksheet. The spreadsheet is initialized with sample data, and buttons are provided to trigger navigation actions.

<html>
<script src="https://jspreadsheet.com/v11/jspreadsheet.js"></script>
<link rel="stylesheet" href="https://jspreadsheet.com/v11/jspreadsheet.css" type="text/css" />
<script src="https://jsuites.net/v5/jsuites.js"></script>
<link rel="stylesheet" href="https://jsuites.net/v5/jsuites.css" type="text/css" />

<div id="spreadsheet"></div>
<br>
<button onclick="mySpreadsheet[0].goto(2, 1)">Go to C2</button>
<button onclick="mySpreadsheet[0].pageUp()">Page Up</button>
<button onclick="mySpreadsheet[0].pageDown()">Page Down</button>
<button onclick="mySpreadsheet[0].left()">Left</button>
<button onclick="mySpreadsheet[0].up()">Up</button>
<button onclick="mySpreadsheet[0].right()">Right</button>
<button onclick="mySpreadsheet[0].down()">Down</button>
<button onclick="mySpreadsheet[0].first()">First Cell</button>
<button onclick="mySpreadsheet[0].last()">Last Cell</button>

<script>
// Set your JSS license key (The following key only works for one day)
jspreadsheet.setLicense('OGFjYzBkMWZjN2I2NWYyMjc4NTMyMzNlMjE4Zjc4OTlkODQ0MjgxOGI0NWUyYjFhMjZjZDg4MjRhNWI4ODJiYTlhNThiNDcwZjNjNzBiMjc1YTcyOGEzNTMzNDkyODk3ZTEzZGM0MDljMDgwYmQ1MDcxZmRmMWQxN2Q0MmM3ZDAsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE56YzBNVEE1TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// Create a new spreadsheet
let mySpreadsheet = jspreadsheet(document.getElementById('spreadsheet'), {
    worksheets: [{
        data: [
            ['Mazda', 2001, 2000],
            ['Peugeot', 2010, 5000],
            ['Honda', 2020, 3000],
            ['Fiat', 2015, 4000],
        ],
        worksheetName: 'Sheet1',
        minDimensions: [6, 6],
    }],
    namespace: 'c4b0065e-d777-4b9b-b89f-1c03c01ccf96',
}).worksheets[0];
</script>
</html>

Edit this page on GitHub