TdxSpreadSheetConditionalFormattingRuleDataBarStyle.FillMode Property

Specifies the fill mode of data bars in all cells affected by a “Data Bar“ conditional formatting rule.

Declaration

property FillMode: TdxSpreadSheetConditionalFormattingRuleDataBarFillMode read; write; default dbfmGradient;

Property Value

Type	Default
TdxSpreadSheetConditionalFormattingRuleDataBarFillMode	dbfmGradient

Remarks

Use this property to select between a solid color and linear gradient filling all data bars within the formatted cells. The gradient is always based on two points – the color specified by the PositiveBarColor and/or NegativeBarColor properties and the white color. By default, both the positive and negative data bars have the same fill colors or gradients. Refer to the TdxSpreadSheetConditionalFormattingRuleDataBarFillMode type description for additional information.

End-users can select the required data bar fill mode by using the “Fill mode” combo box in the “Data Bar Rule Style Settings” dialog:

The default FillMode property value is dbfmGradient.