Class ConditionValue

Represents a condition value for color scale and icon set conditional formatting rules.

Inheritance

object

ConditionValue

Inherited Members

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Namespace: DRIT.Spreadsheet.ConditionalFormatting

Assembly: DRIT.Spreadsheet.dll

Syntax

public class ConditionValue

Constructors

ConditionValue()

Initializes a new instance of the ConditionValue class with default values.

Declaration

public ConditionValue()

ConditionValue(ConditionValueType, double)

Initializes a new instance of the ConditionValue class with a numeric value.

Declaration

public ConditionValue(ConditionValueType type, double value)

Parameters

Type	Name	Description
ConditionValueType	type	The condition value type.
double	value	The numeric value.

ConditionValue(ConditionValueType, string)

Initializes a new instance of the ConditionValue class with a formula.

Declaration

public ConditionValue(ConditionValueType type, string formula)

Parameters

Type	Name	Description
ConditionValueType	type	The condition value type.
string	formula	The formula string.

Properties

Formula

Specifies the formula for formula-based conditions.

Declaration

public string Formula { get; set; }

Property Value

Type	Description
string

GreaterThanOrEqual

Gets or sets whether the condition uses greater than or equal comparison.

Declaration

public bool GreaterThanOrEqual { get; set; }

Property Value

Type	Description
bool

Type

Specifies the condition value type.

Declaration

public ConditionValueType Type { get; set; }

Property Value

Type	Description
ConditionValueType

Value

Specifies the numeric value for this condition.

Declaration

public double Value { get; set; }

Property Value

Type	Description
double