TdxSpreadSheetConditionalFormattingRuleDataBarAxisPosition Enum

Enumerates cell axis display modes for data bars.

Declaration

TdxSpreadSheetConditionalFormattingRuleDataBarAxisPosition = (
    dbapAuto,
    dbapMidpoint,
    dbapNone
);

Members

Name
dbapAuto
dbapMidpoint
dbapNone

Remarks

Options include:

Value	Description	Example
dbapAuto	In this mode, the axis position splits all affected cells in two parts corresponding to the largest positive and negative data bars. The axis position automatically updates every time the maximum or minimum values change within the affected cell area(s). Use the conditional formatting rule’s Style.Direction property to select the actual data bar directions.
dbapMidpoint	A "Data Bar" conditional formatting rule centers data bar axes in all affected cells regardless of the minimum and maximum threshold values and its Style.Direction property value. Like in the dbapAuto mode, the axis position corresponds to a zero value.
dbapNone	A “Data Bar”conditional formatting rule does not display data bar axes in this mode. The data bar origin corresponds to the lowest value (that is, the minimum threshold) within the affected cell area(s). Both the positive and negative value bars have the same direction depending on the rule’s Style.Direction property value.

The “Data Bar“ conditional formatting rule’s Style.AxisPosition property references the TdxSpreadSheetConditionalFormattingRuleDataBarAxisPosition type.