[]
        
(Showing Draft Content)

GrapeCity.Spreadsheet.IDatabar

IDatabar Interface

Represents a data bar conditional formatting rule.

Namespace: GrapeCity.Spreadsheet
Assembly: GrapeCity.Spreadsheet.dll
Syntax
public interface IDatabar : IFormatCondition
Public Interface IDatabar
    Inherits IFormatCondition

Properties

Name Description
AxisColor

Returns 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

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

BarColor

Returns a FormatColor object that you can use to modify the color of the bars in a data bar conditional format.

BarFillType

Gets or sets how a data bar is filled with color.

Direction

Gets or sets the direction the databar is displayed.

MaxPoint

Returns a IConditionValue object that specifies how the longest bar is evaluated for a data bar conditional format.

MinPoint

Returns a IConditionValue object that specifies how the shortest bar is evaluated for a data bar conditional format.

NegativeBarFormat

Returns the INegativeBarFormat object associated with a data bar conditional formatting rule.

PercentMax

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

PercentMin

Gets or sets an integer 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 if the data bar conditional format is applied to the range.