TdxSpreadSheetConditionalFormattingRuleDataBarAxisPosition Enum
In This Article
Enumerates cell axis display modes for data bars.
#Declaration
Delphi
TdxSpreadSheetConditionalFormattingRuleDataBarAxisPosition = (
dbapAuto,
dbapMidpoint,
dbapNone
);
#Members
Name |
---|
dbap
|
dbap
|
dbap
|
#Remarks
Options include:
Value | Description | Example |
---|---|---|
dbap |
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 |
![]() |
dbap |
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. |
![]() |
dbap |
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 |
![]() |
The “Data Bar“ conditional formatting rule’s Style.AxisPosition property references the TdxSpreadSheetConditionalFormattingRuleDataBarAxisPosition type.
See Also