Edit

Excel.Interfaces.ConditionalFormatRuleLoadOptions interface

  • Reference
Package:
excel

Represents a rule, for all traditional rule/format pairings.

Remarks

[ API set: ExcelApi 1.6 ]

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).
formula

The formula, if required, on which to evaluate the conditional format rule.
formulaLocal

The formula, if required, on which to evaluate the conditional format rule in the user's language.
formulaR1C1

The formula, if required, on which to evaluate the conditional format rule in R1C1-style notation.

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

formula

The formula, if required, on which to evaluate the conditional format rule.

formula?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.6 ]

formulaLocal

The formula, if required, on which to evaluate the conditional format rule in the user's language.

formulaLocal?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.6 ]

formulaR1C1

The formula, if required, on which to evaluate the conditional format rule in R1C1-style notation.

formulaR1C1?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.6 ]