Class DataBar

Namespace

Spire.Xls

Assembly

Spire.XLS.dll

Represents a data bar conditional formating rule.

public class DataBar

Inheritance

object

DataBar

Inherited Members

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Properties

AxisColor

Gets the color of the axis for cells with conditional formatting as data bars.

public Color AxisColor { get; set; }

Property Value

Color

AxisPosition

Gets or sets the position of the axis of the data bars specified by a conditional formatting rule.

public DataBarAxisPosition AxisPosition { get; set; }

Property Value

DataBarAxisPosition

BarBorder

Gets an object that specifies the border of a data bar.

public DataBarBorder BarBorder { get; }

Property Value

DataBarBorder

BarColor

Gets or sets the color of the bar in a data bar condition format.

public Color BarColor { get; set; }

Property Value

Color

BarFillType

public DataBarFillType BarFillType { get; set; }

Property Value

DataBarFillType

Direction

Gets or sets the direction the databar is displayed.

public TextDirectionType Direction { get; set; }

Property Value

TextDirectionType

MaxPoint

The longest bar is evaluated for a data bar conditional format.

public ConditionValue MaxPoint { get; }

Property Value

ConditionValue

MinPoint

The shortest bar is evaluated for a data bar conditional format.

public ConditionValue MinPoint { get; }

Property Value

ConditionValue

NegativeBarFormat

Gets the NegativeBarFormat object associated with a data bar conditional formatting rule.

public NegativeBarFormat NegativeBarFormat { get; }

Property Value

NegativeBarFormat

PercentMax

Gets or sets a value that specifies the length of the longest data bar as a percentage of cell width.

public int PercentMax { get; set; }

Property Value

int

PercentMin

Gets or sets a value that specifies the length of the shortest data bar as a percentage of cell width.

public int PercentMin { get; set; }

Property Value

int

ShowValue

Gets or sets a Boolean value that specifies if the value in the cell is displayed.

public bool ShowValue { get; set; }

Property Value

bool