lockCell

protects a cell or a range of cells from editing

void lockCell(number|object row,number|object column, [boolean state,string page] );

row

number|objectthe row id or the row and column numbers of the first cell in the range column

number|objectthe column id or the row and column numbers of the last cell in the range state

booleantrue - to lock a cell, false - to unlock it (true by default) pagestringoptional, the name of the sheet

Example

// locks one cell
$$("ssheet").lockCell(2, 3, true);
// locks a range of cells
$$("ssheet").lockCell({row:1, column:1}, {row:7, column:3}, true, "Sheet1");

Related samples

Lock cells

Details

If the cell isn't specified, the selected cell will be locked.

See also

API

isCellLocked

Articles

Working with Cell Content

Back to top

If you have not checked yet, be sure to visit site of our main product Webix html5 framework and page of web spreadsheet product.