TdxSpreadSheetConditionalFormattingRuleDataBar Class

A “Data Bar“ conditional formatting rule.

Declaration

TdxSpreadSheetConditionalFormattingRuleDataBar = class(
    TdxSpreadSheetConditionalFormattingRuleCustomScale
)

Remarks

This rule visualizes all numeric cell values within the affected area(s) as customizable horizontal data bars.

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

Designate one or more cell ranges to which the rule applies (Areas);
Set or adjust the minimum and maximum threshold values (MinValue and MaxValue);
Set the rule’s evaluation priority (Index);
Hide or show values in the affected cells (ShowValue);
Customize the appearance of displayed data bars (Style);
Copy the rule between cells and/or cell ranges (Clone).

To create a “Data Bar” 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 (TdxSpreadSheetConditionalFormattingRuleDataBar) 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 a “Data Bar” rule’s type-specific members, cast the rule to the TdxSpreadSheetConditionalFormattingRuleDataBar class.