Excel.Interfaces.FormatProtectionLoadOptions interface

Represents the format protection of a range object.

Remarks

[ API set: ExcelApi 1.2 ]

Properties

$all

Specifying $all for the LoadOptions loads all the scalar properties (e.g.: Range.address) but not the navigational properties (e.g.: 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 LoadOptions loads all the scalar properties (e.g.: Range.address) but not the navigational properties (e.g.: 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 ]