Back to Devexpress

DataBarConditionalFormatting Properties

officefileapi-devexpress-dot-spreadsheet-dot-databarconditionalformatting-dot-underscore-properties.md

latest4.5 KB
Original Source

DataBarConditionalFormatting Properties

Represents a data bar conditional formatting rule.

NameDescription
AxisColorGets or sets the color of the axis between positive and negative bars.
AxisPositionGets or sets the axis position in a cell.
BorderColorGets or sets the data bar border color.
ColorGets or sets the color associated with data bars in the data bar conditional format.
DirectionGets or sets the direction of data bars.
GradientFillGets or sets whether the gradient fill is applied to data bars.
HighBoundReturns the ConditionalFormattingValue object that specifies how the longest bar is evaluated for the data bar conditional format.
LowBoundReturns the ConditionalFormattingValue object that specifies how the shortest bar is evaluated for the data bar conditional format.
MaxLengthGets or sets the maximum length of the data bar, as a percentage of the cell width.
MinLengthGets or sets the minimum length of the data bar, as a percentage of the cell width.
NegativeBarBorderColorGets or sets the negative bar border color.
NegativeBarColorGets or sets the negative bar fill color.
PrioritySpecifies the priority of the conditional formatting rule. Inherited from ConditionalFormatting.
RangeGets or sets the range of cells to which the conditional formatting rule is applied. Inherited from ConditionalFormatting.
RangesObsolete. Gets or sets a collection of ranges, to which the conditional format is applied. Inherited from ConditionalFormatting.
ShowValueIndicates whether to show the values of cells to which the data bar conditional formatting rule is applied.
StopIfTrueSpecifies whether the rules with lower priority can be applied. Inherited from ConditionalFormatting.

See Also

DataBarConditionalFormatting Interface

DataBarConditionalFormatting Members

DevExpress.Spreadsheet Namespace