unlock

unlocks a locked cell(s)

void unlock(string cell);

Parameters

cellstringthe id(s) of a cell(s) or a range of cells

Example

// 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");

Details

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.

See also
Back to top