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.

Example

The TdxSpreadSheetConditionalFormattingRuleDataBar class has public API members that allow you to do the following:

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.