ExcelScript.FormatProtection interface

Package:

ExcelScript

Represents the format protection of a range object.

Methods

getFormulaHidden()	Specifies if Excel hides the formula for the cells in the range. A null value indicates that the entire range doesn't have a uniform formula hidden setting.
getLocked()	Specifies if Excel locks the cells in the object. A null value indicates that the entire range doesn't have a uniform lock setting.
setFormulaHidden(formulaHidden)	Specifies if Excel hides the formula for the cells in the range. A null value indicates that the entire range doesn't have a uniform formula hidden setting.
setLocked(locked)	Specifies if Excel locks the cells in the object. A null value indicates that the entire range doesn't have a uniform lock setting.

Method Details

getFormulaHidden()

Specifies if Excel hides the formula for the cells in the range. A null value indicates that the entire range doesn't have a uniform formula hidden setting.

getFormulaHidden(): boolean;

Returns

boolean

getLocked()

Specifies if Excel locks the cells in the object. A null value indicates that the entire range doesn't have a uniform lock setting.

getLocked(): boolean;

Returns

boolean

setFormulaHidden(formulaHidden)

Specifies if Excel hides the formula for the cells in the range. A null value indicates that the entire range doesn't have a uniform formula hidden setting.

setFormulaHidden(formulaHidden: boolean): void;

Parameters

formulaHidden

boolean

Returns

void

setLocked(locked)

Specifies if Excel locks the cells in the object. A null value indicates that the entire range doesn't have a uniform lock setting.

setLocked(locked: boolean): void;

Parameters

locked

boolean

Returns

void