close
Documentation
Freeze rows
The spreadsheet freeze rows property helps to sticky some rows floating top on the spreadsheet. The property can be defined programmatically as below:Documentation
Methods
Define or reset the number of freeze rows programmatically.Method | Description |
---|---|
setFreezeRows(number) | Set the freeze rows.setFreezeRows(number: number) : void |
resetFreezeRows() | Reset the freeze rows.resetFreezeRows() : void |
Initial Settings
The following property is available through the initialization of the online spreadsheet.Property | Description |
---|---|
freezeRows: number | Define the number of freeze rows on initialization. |
freezeRowControl: boolean Premium | Enable freeze row manual control. Default: false |
Examples
Basic freeze rows usage.
It is possible to define the viewport when using the freeze rows, as follow:Source code
<html> <script src="https://jspreadsheet.com/v9/jspreadsheet.js"></script> <script src="https://jsuites.net/v4/jsuites.js"></script> <link rel="stylesheet" href="https://jsuites.net/v4/jsuites.css" type="text/css" /> <link rel="stylesheet" href="https://jspreadsheet.com/v9/jspreadsheet.css" type="text/css" /> <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Material+Icons" /> <div id="spreadsheet"></div> <script> // Set your JSS license key (The following key only works for one day) jspreadsheet.setLicense('NjhlNTI4MjFlYzUzNjk2ODVkOGIxMzEzMWE4N2QxNjNkMTM1YjJhNTE4ZTBlMmRjMDMyNjMwNjA0YTkwYjFmZTI5ZmNiNzg0M2FjODk4MDI1YjIyOGE5OGRlNzhkNWYwMTI1NTQyNWViOTg0MzE5MTg2MjEwMDY5OTAyMGFkYjMsZXlKdVlXMWxJam9pU25Od2NtVmhaSE5vWldWMElpd2laR0YwWlNJNk1UWTJNREk0TmpRek5pd2laRzl0WVdsdUlqcGJJbXB6Y0hKbFlXUnphR1ZsZEM1amIyMGlMQ0pqYjJSbGMyRnVaR0p2ZUM1cGJ5SXNJbXB6YUdWc2JDNXVaWFFpTENKamMySXVZWEJ3SWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpJaXdpYzJOdmNHVWlPbHNpZGpjaUxDSjJPQ0lzSW5ZNUlpd2lZMmhoY25Seklpd2labTl5YlhNaUxDSm1iM0p0ZFd4aElpd2ljR0Z5YzJWeUlpd2ljbVZ1WkdWeUlpd2lZMjl0YldWdWRITWlMQ0pwYlhCdmNuUWlMQ0ppWVhJaUxDSjJZV3hwWkdGMGFXOXVjeUlzSW5ObFlYSmphQ0pkTENKa1pXMXZJanAwY25WbGZRPT0='); // Create a new spreadsheet jspreadsheet(document.getElementById('spreadsheet'), { worksheets: [{ minDimensions: [50,20], tableOverflow: true, tableWidth: '800px', freezeRows: 4, }] }); </script> </html>
Enable manual freeze controls Premium
Enable the interface controls for manual adjustments.Source code
<html> <script src="https://jspreadsheet.com/v9/jspreadsheet.js"></script> <script src="https://jsuites.net/v4/jsuites.js"></script> <link rel="stylesheet" href="https://jsuites.net/v4/jsuites.css" type="text/css" /> <link rel="stylesheet" href="https://jspreadsheet.com/v9/jspreadsheet.css" type="text/css" /> <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Material+Icons" /> <div id="spreadsheet"></div> <script> // Set your JSS license key (The following key only works for one day) jspreadsheet.setLicense('NjhlNTI4MjFlYzUzNjk2ODVkOGIxMzEzMWE4N2QxNjNkMTM1YjJhNTE4ZTBlMmRjMDMyNjMwNjA0YTkwYjFmZTI5ZmNiNzg0M2FjODk4MDI1YjIyOGE5OGRlNzhkNWYwMTI1NTQyNWViOTg0MzE5MTg2MjEwMDY5OTAyMGFkYjMsZXlKdVlXMWxJam9pU25Od2NtVmhaSE5vWldWMElpd2laR0YwWlNJNk1UWTJNREk0TmpRek5pd2laRzl0WVdsdUlqcGJJbXB6Y0hKbFlXUnphR1ZsZEM1amIyMGlMQ0pqYjJSbGMyRnVaR0p2ZUM1cGJ5SXNJbXB6YUdWc2JDNXVaWFFpTENKamMySXVZWEJ3SWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpJaXdpYzJOdmNHVWlPbHNpZGpjaUxDSjJPQ0lzSW5ZNUlpd2lZMmhoY25Seklpd2labTl5YlhNaUxDSm1iM0p0ZFd4aElpd2ljR0Z5YzJWeUlpd2ljbVZ1WkdWeUlpd2lZMjl0YldWdWRITWlMQ0pwYlhCdmNuUWlMQ0ppWVhJaUxDSjJZV3hwWkdGMGFXOXVjeUlzSW5ObFlYSmphQ0pkTENKa1pXMXZJanAwY25WbGZRPT0='); // Create a new spreadsheet jspreadsheet(document.getElementById('spreadsheet'), { worksheets: [{ minDimensions: [50,20], tableOverflow: true, tableWidth: '800px', freezeRowControl: true, freezeColumnControl: true, }] }); </script> </html>