DataBar Class |
Represents a data bar conditional formating rule.
Inheritance Hierarchy
System
Object
Spire.Xls DataBar
Spire.Xls DataBar
Namespace: Spire.Xls
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
The DataBar type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
|
AxisColor |
Gets the color of the axis for cells with conditional formatting as data bars.
|
|
|
AxisPosition |
Gets or sets the position of the axis of the data bars specified by a conditional formatting rule.
|
|
|
BarBorder |
Gets an object that specifies the border of a data bar.
|
|
|
BarColor |
Gets or sets the color of the bar in a data bar condition format.
|
|
|
BarFillType |
Gets or sets the type of fill for the data bar.
|
|
|
Direction |
Gets or sets the direction the databar is displayed.
|
|
|
MaxPoint |
The longest bar is evaluated for a data bar conditional format.
|
|
|
MinPoint |
The shortest bar is evaluated for a data bar conditional format.
|
|
|
NegativeBarFormat |
Gets the NegativeBarFormat object associated with a data bar conditional formatting rule.
|
|
|
PercentMax |
Gets or sets a value that specifies the length of the longest data bar as a percentage of cell width.
|
|
|
PercentMin |
Gets or sets a value that specifies the length of the shortest data bar as a percentage of cell width.
|
|
|
ShowValue |
Gets or sets a Boolean value that specifies if the value in the cell is displayed.
|
Methods
| Name | Description | |
|---|---|---|
|
Equals |
Determines whether the specified object is equal to the current object.
(Inherited from
Object
.)
|
|
Finalize |
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from
Object
.)
|
|
|
GetHashCode |
Serves as the default hash function.
(Inherited from
Object
.)
|
|
|
GetType |
Gets the
Type
of the current instance.
(Inherited from
Object
.)
|
|
|
MemberwiseClone |
Creates a shallow copy of the current
Object
.
(Inherited from
Object
.)
|
|
|
ToString |
Returns a string that represents the current object.
(Inherited from
Object
.)
|
See Also
