Defines a format of the databars in a conditional format.
Syntax
Unit: FlexCel.Core
TConditionalFormatDefDataBar = class(TConditionalFormatDef);
Constructors
| Name |
Description |
| Create |
Creates an empty instance, where no format applies.
|
Methods
| Name |
Description |
| CheckIsValid |
Checks if the format definition is valid. This check will be applied automatically when you try to add a conditional format to a sheet, so there is no need to call this method directly. But you can use it to know if a conditional format will be rejected when you try to add it.
|
| Clone |
Returns a deep copy of the object.
|
| Equals |
Returns true if this object is equal to obj.
|
| GetHashCode |
Returns the hashcode for this object.
|
Properties
| Name |
Description |
| MinLengthValue |
A condition that specifies the value that corresponds with the minimum length of the databar.
|
| MaxLengthValue |
A condition that specifies the value that corresponds with the maximum length of the databar.
|
| Colors |
Colors that define the databar.
|
| MinBarWidth |
The minimum length of the data bar, as a percentage of the cell width.
|
| MaxBarWidth |
The maximum length of the data bar, as a percentage of the cell width.
|
| ShowValues |
If true, we will show the values in the cell where the databar is.
|
| HasBorders |
If true the databar has a border.
|
| IsGradient |
If true the fill will be a gradient, otherwise it will be a solid color.
|
| Direction |
Direction of the databar.
|
| IsNegativeBarColorSameAsPositive |
If true, the negative bars have the same color as the positives.
|
| IsNegativeBarBorderColorSameAsPositive |
If true, the borders of the negative bars are the same color as the positives.
|
| AxisPosition |
Position for the axis.
|