TdxSpreadSheetConditionalFormattingRuleIconSet Class

An “Icon Set“ conditional formatting rule.

Declaration

TdxSpreadSheetConditionalFormattingRuleIconSet = class(
    TdxSpreadSheetConditionalFormattingRuleCustomScale
)

Remarks

This rule differentiates numeric values within one or more affected cell ranges by painting icons within the corresponding cells whose values are equal to or exceed specific thresholds associated with the icons.

The TdxSpreadSheetConditionalFormattingRuleIconSet class provides the following members that allow you to:

Designate one or more cell ranges to which the rule applies (Areas);
Select the required icon preset by its identifier (PresetName);
Switch between the normal and reverse icon order within the selected preset (Order);
Customize the settings of thresholds corresponding to icons within the selected preset (Stops);
Hide or show values in the formatted cells (ShowValue);
Set the rule’s evaluation priority (Index);
Copy the rule between cells and/or cell ranges (Clone).

To create an “Icon Set” conditional formatting rule, you can:

Call a conditional formatting controller’s overloaded Add procedure (TdxSpreadSheetCustomConditionalFormatting.Add or TcxDataControllerConditionalFormatting.Add) and pass the rule’s class-reference (TdxSpreadSheetConditionalFormattingRuleIconSet) as the ARuleClass parameter;
Call the Create constructor and pass the target conditional formatting controller as the AOwner parameter.

The conditional formatting controller’s Rules property provides indexed access to individual rules. To expose an “Icon Set” rule’s type-specific members, cast the rule to the TdxSpreadSheetConditionalFormattingRuleIconSet class.