Table of Contents

Class ExcelConditionalFormattingIconDataBarValue

Namespace
OfficeOpenXml.ConditionalFormatting
Assembly
EPPlus.dll

18.3.1.11 cfvo (Conditional Format Value Object) Describes the values of the interpolation points in a gradient scale.

public class ExcelConditionalFormattingIconDataBarValue
Inheritance
ExcelConditionalFormattingIconDataBarValue
Inherited Members

Properties

CustomIcon

If not custom is null. If user assigns to it holds icon value.

public eExcelconditionalFormattingCustomIcon? CustomIcon { get; set; }

Property Value

eExcelconditionalFormattingCustomIcon?

Formula

The Formula of the Object Value

Keep in mind that Addresses in this property should be Absolute not relative

Yes: $A$1

No: A1

public string Formula { get; set; }

Property Value

string

GreaterThanOrEqualTo

Greater Than Or Equal To Set to false to only apply an icon when greaterThan

public bool GreaterThanOrEqualTo { get; set; }

Property Value

bool

Type

Value type

public eExcelConditionalFormattingValueObjectType Type { get; set; }

Property Value

eExcelConditionalFormattingValueObjectType

Value

The value

public double Value { get; set; }

Property Value

double