Excel.Interfaces.FormatProtectionLoadOptions interface

  • Reference
Package:
excel

Represents the format protection of a range object.

Remarks

[ API set: ExcelApi 1.2 ]

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 ]