TdxSpreadSheetCustomConditionalFormattingRule.Index Property

Specifies the conditional formatting rule’s zero-based index in the conditional formatting controller.

Declaration

property Index: Integer read; write;

Property Value

Type
Integer

Remarks

The conditional formatting controller assigns consecutive numbers starting from 0 to the Index properties of individual rules according to their order of creation. In addition to rule identification within the controller, the Index property value determines the rule’s evaluation priority and position in the Conditional Formatting Rules Manager dialog:

You can use this property to change the conditional formatting rule’s precedence. For instance, if the Index property is set to 0, the rule has the highest priority. Since all rule indexes within the same conditional formatting controllers are unique, changing the Index property value automatically updates indexes (thus changing evaluation priorities) of all the other rules.

The conditional formatting controller evaluates rule precedences only if two or more rules affect the same area(s). To prevent all rules with lower priority compared to the current rule from affecting the same area(s), set the StopIfTrue property to True. Note that not all conditional formatting rule classes publish this property.