Skip to main content

unlock()

Description​

Unlocks a locked cell(s)

Usage​

unlock(cell: string): void;

Parameters​

  • cell - (required) the id(s) of a cell(s) or a range of cells

Example​

const spreadsheet = new dhx.Spreadsheet("spreadsheet", {});
spreadsheet.parse(data);

// unlocks a cell
spreadsheet.unlock("A1");

// unlocks a range of cells
spreadsheet.unlock("A1:C1");

// unlocks specified cells
spreadsheet.unlock("A1,B5,B7,D4:D6");
info

Starting with v4.1, the reference to a cell or a range of cells can be specified in the following format:

spreadsheet.unlock("sheet1!A2");

where sheet1 is the name of the tab.

In case the name of the tab isn't specified, the method will unlock the cell(s) of the active tab.