Interface IExcelConditionalFormattingDataBarGroup

IExcelConditionalFormattingDataBar

Inherited Members
Namespace: OfficeOpenXml.ConditionalFormatting.Contracts
Assembly: EPPlus.dll
Syntax
public interface IExcelConditionalFormattingDataBarGroup : IExcelConditionalFormattingRule

Properties

AxisColor

Color of the axis between negative and positive values

Declaration
ExcelDxfColor AxisColor { get; }
Property Value
Type Description
ExcelDxfColor

AxisPosition

What position the axis between positive and negative values is to be put at.

Declaration
eExcelDatabarAxisPosition AxisPosition { get; set; }
Property Value
Type Description
eExcelDatabarAxisPosition

Border

Wheter there is a border color or not. False by default. Is set to true if BorderColor or NegativeBorderColor is set

Declaration
bool Border { get; set; }
Property Value
Type Description
System.Boolean

BorderColor

Border color of databar. Setting any property sets Border to true

Declaration
ExcelDxfColor BorderColor { get; }
Property Value
Type Description
ExcelDxfColor

Color

The color of the databar. ShortHand for FillColor.Color

Declaration
Color Color { get; set; }
Property Value
Type Description
System.Drawing.Color

Direction

Direction of the Databar

Declaration
eDatabarDirection Direction { get; set; }
Property Value
Type Description
eDatabarDirection

FillColor

Fill color of Databar

Declaration
ExcelDxfColor FillColor { get; }
Property Value
Type Description
ExcelDxfColor

Gradient

If the databar should be a gradient. True by default

Declaration
bool Gradient { get; set; }
Property Value
Type Description
System.Boolean

HighValue

Databar High Value

Declaration
ExcelConditionalFormattingIconDataBarValue HighValue { get; }
Property Value
Type Description
ExcelConditionalFormattingIconDataBarValue

LowValue

Databar Low Value

Declaration
ExcelConditionalFormattingIconDataBarValue LowValue { get; }
Property Value
Type Description
ExcelConditionalFormattingIconDataBarValue

NegativeBarBorderColorSameAsPositive

Wheter negative and positive values should have the same border colour. False by default. Is set to true if NegativeBorderColor is set.

Declaration
bool NegativeBarBorderColorSameAsPositive { get; set; }
Property Value
Type Description
System.Boolean

NegativeBarColorSameAsPositive

Wheter negative and positive values should have the same colour. False by default. Is set to true if NegativeFillColor is set.

Declaration
bool NegativeBarColorSameAsPositive { get; set; }
Property Value
Type Description
System.Boolean

NegativeBorderColor

Border color for negative values Setting any property sets NegativeBarBorderColorSameAsPositive to false

Declaration
ExcelDxfColor NegativeBorderColor { get; }
Property Value
Type Description
ExcelDxfColor

NegativeFillColor

Fill color for negative values Setting any property sets NegativeBarColorSameAsPositive to false

Declaration
ExcelDxfColor NegativeFillColor { get; }
Property Value
Type Description
ExcelDxfColor

ShowValue

ShowValue

Declaration
bool ShowValue { get; set; }
Property Value
Type Description
System.Boolean