locked Method

Gets or sets whether the cell is locked. When the sheet is protected, the locked cell cannot be edited.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GC.Spread.Sheets.CellRange(sheet, row, col, rowCount, colCount, sheetArea);
var returnValue; // Type: any
returnValue = instance.locked(value);

function locked( 
   value : boolean
) : any;

Parameters

value: Set to true to lock the cell.

Return Value

If no value is set, returns whether the cell is locked; otherwise, returns the cell.

Example

The following examples lock the column.

Javascript

activeSheet.getRange(2, -1, 1, -1, GC.Spread.Sheets.SheetArea.viewport).locked(false);

Javascript

activeSheet.getCell(1,1).locked(true);

Javascript

activeSheet.getRange(-1, 3, -1, 1, GC.Spread.Sheets.SheetArea.viewport).locked(true);

Remarks

The default value is true.

Reference

CellRange type