Note

Access to this page requires authorization. You can try signing in or .

Access to this page requires authorization. You can try .

ExcelScript.FormatProtection interface

Package:
ExcelScript

Represents the format protection of a range object.

Remarks

Used by

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

Feedback

Was this page helpful?