Freeze columns
The spreadsheet freezeColumns property helps to sticky an arbitrary number of columns always floating left on the spreadsheet. The property can be defined programatically.
Documentation
Methods
Define or reset the number of freeze columns programmatically.
| Method | Description |
|---|---|
| setFreezeColumns(number) | Set the freeze columns.setFreezeColumns(number: number) : void |
| resetFreezeColumns() | Reset the freeze columns.resetFreezeColumns() : void |
Initial Settings
Define or reset the number of freeze columns programmatically.
| Property | Description |
|---|---|
| freezeColumns: number | Define the number of freeze columns on initialization. |
Examples
Basic freeze column usage.
It is possible to define the viewport when using the freeze columns, as follow:
<html>
<script src="https://jspreadsheet.com/v8/jspreadsheet.js"></script>
<script src="https://jsuites.net/v5/jsuites.js"></script>
<link rel="stylesheet" href="https://jsuites.net/v5/jsuites.css" type="text/css" />
<link rel="stylesheet" href="https://jspreadsheet.com/v8/jspreadsheet.css" type="text/css" />
<div id="spreadsheet"></div>
<script>
jspreadsheet(document.getElementById('spreadsheet'), {
worksheets: [{
minDimensions: [50,10],
tableOverflow: true,
tableWidth: '800px',
freezeColumns: 2
}]
});
</script>
</html>