Interface IExcelConditionalFormattingDataBarGroup¶

Namespace: OfficeOpenXml.ConditionalFormatting.Contracts
Assembly: EPPlus.dll

IExcelConditionalFormattingDataBar

public interface IExcelConditionalFormattingDataBarGroup : IExcelConditionalFormattingRule

Implements¶

IExcelConditionalFormattingRule

Properties¶

AxisColor¶

Color of the axis between negative and positive values

ExcelDxfColor AxisColor { get; }

Property Value¶

ExcelDxfColor

AxisPosition¶

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

eExcelDatabarAxisPosition AxisPosition { get; set; }

Property Value¶

eExcelDatabarAxisPosition

Border¶

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

bool Border { get; set; }

Property Value¶

bool

BorderColor¶

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

ExcelDxfColor BorderColor { get; }

Property Value¶

ExcelDxfColor

Color¶

The color of the databar. ShortHand for FillColor.Color

Color Color { get; set; }

Property Value¶

Color

Direction¶

Direction of the Databar

eDatabarDirection Direction { get; set; }

Property Value¶

eDatabarDirection

FillColor¶

Fill color of Databar

ExcelDxfColor FillColor { get; }

Property Value¶

ExcelDxfColor

Gradient¶

If the databar should be a gradient. True by default

bool Gradient { get; set; }

Property Value¶

bool

HighValue¶

Databar High Value

ExcelConditionalFormattingIconDataBarValue HighValue { get; }

Property Value¶

ExcelConditionalFormattingIconDataBarValue

LowValue¶

Databar Low Value

ExcelConditionalFormattingIconDataBarValue LowValue { get; }

Property Value¶

ExcelConditionalFormattingIconDataBarValue

NegativeBarBorderColorSameAsPositive¶

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

bool NegativeBarBorderColorSameAsPositive { get; set; }

Property Value¶

bool

NegativeBarColorSameAsPositive¶

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

bool NegativeBarColorSameAsPositive { get; set; }

Property Value¶

bool

NegativeBorderColor¶

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

ExcelDxfColor NegativeBorderColor { get; }

Property Value¶

ExcelDxfColor

NegativeFillColor¶

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

ExcelDxfColor NegativeFillColor { get; }

Property Value¶

ExcelDxfColor

ShowValue¶

ShowValue

bool ShowValue { get; set; }

Property Value¶

bool