Note

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

Access to this page requires authorization. You can try .

Excel.Interfaces.FormatProtectionLoadOptions interface

Package:
excel

Represents the format protection of a range object.

Remarks

API set: ExcelApi 1.2

Used by

Properties

$all

Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).
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.
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.

Property Details

$all

Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).

$all?: boolean;

Property Value

boolean

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.

formulaHidden?: boolean;

Property Value

boolean

Remarks

API set: ExcelApi 1.2

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.

locked?: boolean;

Property Value

boolean

Remarks

API set: ExcelApi 1.2

Feedback

Was this page helpful?