TConditionalFormatDefDataBar Class

Defines a format of the databars in a conditional format.

Syntax

Namespace: FlexCel.Core

public class TConditionalFormatDefDataBar: TConditionalFormatDef

Constructors

Name	Description
TConditional​Format​DefDataBar	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.
IsNegativeBar​Color​Same​AsPositive	If true, the negative bars have the same color as the positives.
IsNegativeBar​Border​Color​Same​AsPositive	If true, the borders of the negative bars are the same color as the positives.
AxisPosition	Position for the axis.