Show / Hide Table of Contents

Class ExcelConditionalFormattingIconDataBarValue

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

Inheritance
object
ExcelConditionalFormattingIconDataBarValue
Inherited Members
object.Equals(object)
object.Equals(object, object)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object, object)
object.ToString()
Namespace: OfficeOpenXml.ConditionalFormatting
Assembly: EPPlus.dll
Syntax
public class ExcelConditionalFormattingIconDataBarValue

Properties

CustomIcon

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

Declaration
public eExcelconditionalFormattingCustomIcon? CustomIcon { get; set; }
Property Value
Type Description
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

Declaration
public string Formula { get; set; }
Property Value
Type Description
string

GreaterThanOrEqualTo

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

Declaration
public bool GreaterThanOrEqualTo { get; set; }
Property Value
Type Description
bool

Type

Value type

Declaration
public eExcelConditionalFormattingValueObjectType Type { get; set; }
Property Value
Type Description
eExcelConditionalFormattingValueObjectType

Value

The value

Declaration
public double Value { get; set; }
Property Value
Type Description
double
In this article
Back to top Generated by DocFX