TdxSpreadSheetConditionalFormattingRuleDataBarStyle Class
Stores appearance settings of data bars displayed by a Data Bar conditional formatting rule in its affected cell areas.
Declaration
TdxSpreadSheetConditionalFormattingRuleDataBarStyle = class(
TPersistent
)Remarks
All Data Bar conditional formatting rules display customizable data bars in addition to or instead the numeric values stored in affected cells:
Main API Members
The TdxSpreadSheetConditionalFormattingRuleDataBarStyle class has public API members that allow you to do the following:
Change the default border and fill colors of positive data bars (PositiveBarBorderColor and PositiveBarColor).
Identify the border and fills color currently used to show negative data bars (ActualNegativeBarBorderColor and ActualNegativeBarColor).
Set independent colors for displaying negative data bars (NegativeBarBorderColor and NegativeBarColor).
Switch between solid and liner gradient fill for all data bars displayed by the rule (FillMode).
Explicitly specify the required data bar direction (Direction).
Hide or show data bar axes and determine their color (AxisPosition and AxisColor).
Direct TdxSpreadSheetConditionalFormattingRuleDataBarStyle Class Reference
A Data Bar conditional formatting rule’s Style property references a TdxSpreadSheetConditionalFormattingRuleDataBarStyle object.