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.



Define or reset the number of freeze columns programmatically.
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.
freezeColumns: numberDefine the number of freeze columns on initialization.


Basic freeze column usage.

It is possible to define the viewport when using the freeze columns, as follow:

Source code

<script src=""></script>
<script src=""></script>
<link rel="stylesheet" href="" type="text/css" />
<link rel="stylesheet" href="" type="text/css" />

<div id="spreadsheet"></div>

jspreadsheet(document.getElementById('spreadsheet'), {
    worksheets: [{
        minDimensions: [50,10],
        tableOverflow: true,
        tableWidth: '800px',
        freezeColumns: 2