Class ExcelConditionalFormattingIconDataBarValue
18.3.1.11 cfvo (Conditional Format Value Object) Describes the values of the interpolation points in a gradient scale.
Inheritance
System.Object
ExcelConditionalFormattingIconDataBarValue
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: OfficeOpenXml.ConditionalFormatting
Assembly: EPPlus.dll
Syntax
public class ExcelConditionalFormattingIconDataBarValueProperties
CustomIcon
If not custom is null. If user assigns to it holds icon value.
Declaration
public eExcelconditionalFormattingCustomIcon? CustomIcon { get; set; }Property Value
| Type | Description |
|---|---|
| System.Nullable<eExcelconditionalFormattingCustomIcon> |
Formula
The Formula of the Object Value
Keep in mind that Addresses in this property should be Absolute not relativeYes: $A$1
No: A1
Declaration
public string Formula { get; set; }Property Value
| Type | Description |
|---|---|
| System.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 |
|---|---|
| System.Boolean |
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 |
|---|---|
| System.Double |