Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

TdxSpreadSheetConditionalFormattingRuleDataBarStyle.FillMode Property

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

#Declaration

Delphi
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.

See Also