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 programatically.
MethodDescription
setFreezeColumns(number) Set the freeze columns.
setFreezeColumns(number: number) : void
resetFreezeColumns() Reset the freeze columns.
resetFreezeColumns() : void


Initial Settings

The following property is available through the initialization of the online spreadsheet.
PropertyDescription
freezeColumns: numberDefine 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:




Source code

<html>
<script src="https://jspreadsheet.com/v8/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/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>