TdxSpreadSheetCustomConditionalFormattingRule Type

The base class for all classes that implement conditional formatting rules.

Declaration

TdxSpreadSheetCustomConditionalFormattingRule = dxSpreadSheetConditionalFormatting.TdxSpreadSheetCustomConditionalFormattingRule;

Referenced Class

Type	Description
TdxSpreadSheetCustomConditionalFormattingRule	A conditional formatting rule.

Remarks

This class implements the core conditional formatting rule functionality including settings common to all rule types. The TdxSpreadSheetCustomConditionalFormattingRule class provides the following members that allow you to:

• Create a conditional formatting rule (Create.

• Specify one or more cells/cell ranges affected by the conditional formatting rule (Areas).

• Specify the conditional formatting rule evaluation priority (Index).

• Specify if style-based conditional formatting rules with lower precedence affect the same cells (StopIfTrue).

• Apply the rule’s copy to a different cell or cell range (Clone).

• Persist the conditional formatting rule in a stream (SaveToStream and LoadFromStream).

• Access the conditional formatting controller to which the rule belongs (Owner).

• Improve the application performance by optimizing the rule modification code (BeginUpdate and EndUpdate).

You do not need to create instances of the TdxSpreadSheetCustomConditionalFormattingRule class, use its descendants instead. You can call the following methods to create a specific formatting rule:

• Either of the conditional formatting controller‘s overloaded Add procedures passing a class-reference to the corresponding TdxSpreadSheetCustomConditionalFormattingRule descendant as the ARuleClass parameter;

• The Create constructor passing the target conditional formatting controller as the AOwner parameter.