Table of Contents

Interface IExcelConditionalFormattingDataBarGroup

Namespace
OfficeOpenXml.ConditionalFormatting.Contracts
Assembly
EPPlus.dll

IExcelConditionalFormattingDataBar

public interface IExcelConditionalFormattingDataBarGroup : IExcelConditionalFormattingRule
Inherited Members

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