DataBarStyle Class

Namespace:
GemBox.Spreadsheet.ConditionalFormatting
Assembly:
GemBox.Spreadsheet.dll

Represents an appearance settings of a data bar.

public sealed class DataBarStyle
Public NotInheritable Class DataBarStyle
Inheritance:
System.Object
DataBarStyle

Properties

AxisColor

Gets or sets the data bar axis color.

public SpreadsheetColor AxisColor { get; set; }
Public Property AxisColor As SpreadsheetColor
Property Value
SpreadsheetColor

The data bar axis color.

AxisPosition

Gets or sets the data bar axis position.

public DataBarAxisPosition AxisPosition { get; set; }
Public Property AxisPosition As DataBarAxisPosition
Property Value
DataBarAxisPosition

The data bar axis position.

BorderColor

Gets or sets the data bar border color.

If border color IsEmpty, then data bar won't have any border.

public SpreadsheetColor BorderColor { get; set; }
Public Property BorderColor As SpreadsheetColor
Property Value
SpreadsheetColor

The data bar border color.

Direction

Gets or sets the data bar direction.

public DataBarDirection Direction { get; set; }
Public Property Direction As DataBarDirection
Property Value
DataBarDirection

The data bar direction.

FillColor

Gets or sets the data bar fill color.

public SpreadsheetColor FillColor { get; set; }
Public Property FillColor As SpreadsheetColor
Property Value
SpreadsheetColor

The data bar fill color.

GradientFill

Gets or sets a value indicating whether the data bar FillColor is gradient or solid.

Default value is false (data bar FillColor is solid).

public bool GradientFill { get; set; }
Public Property GradientFill As Boolean
Property Value
System.Boolean

true if the data bar FillColor is gradient; otherwise, false.

NegativeBorderColor

Gets or sets the data bar border color for negative values.

If negative data bar border color IsEmpty, then data bar border color for negative values is same as for positive values.

public SpreadsheetColor NegativeBorderColor { get; set; }
Public Property NegativeBorderColor As SpreadsheetColor
Property Value
SpreadsheetColor

The data bar border color for negative values.

NegativeFillColor

Gets or sets the data bar fill color for negative values.

If negative data bar fill color IsEmpty, then data bar fill color for negative values is same as for positive values.

public SpreadsheetColor NegativeFillColor { get; set; }
Public Property NegativeFillColor As SpreadsheetColor
Property Value
SpreadsheetColor

The data bar fill color for negative values.

Methods

ToString()

Returns a System.String that represents this DataBarStyle instance.

public override string ToString()
Public Overrides Function ToString As String
Returns
System.String

A System.String that represents this DataBarStyle instance.

Overrides
System.Object.ToString()
Remarks

This method should be used primarily for debugging purposes and should be considered volatile (format of its return value might change in future versions).