TdxSpreadSheetConditionalFormattingRuleDataBarStyle.Direction Property

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

Declaration

property Direction: TdxSpreadSheetConditionalFormattingRuleDataBarDirection read; write; default dbdAuto;

Property Value

Type	Default
TdxSpreadSheetConditionalFormattingRuleDataBarDirection	dbdAuto

Remarks

You can use this property to explicitly specify the direction of positive data bars that is determined by the conditional formatting rule’s Owner.Owner.IsRightToLeft function result by default. Refer to the TdxSpreadSheetConditionalFormattingRuleDataBarDirection type description for detailed information on all available options.

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

Note

If the AxisPosition property is set to dbapNone, both the positive and negative data bars have the same direction; in all other cases the positive and negative bars are facing in opposite directions.

The default Direction property value is dbdAuto.