GrapeCity.Documents.Excel.IIconCriterion

Interface IIconCriterion

Namespace

GrapeCity.Documents.Excel

Assembly

GcDocs.Excel.dll

Represents the criterion for an individual icon in an icon set. The criterion specifies the range of values and the threshold type associated with the icon in an icon set conditional formatting rule.

public interface IIconCriterion

Properties

Icon

Gets or sets the icon for a criterion in an icon set conditional formatting rule.

IconType Icon { get; set; }

Property Value

IconType

Index

Gets a value that indicates which threshold the criteria represents.

int Index { get; }

Property Value

int

Operator

Returns or sets one of the constants of the FormatConditionOperator enumeration, which specifes if the threshold is "greater than" or "greater than or equal to" the threshold value.

FormatConditionOperator Operator { get; set; }

Property Value

FormatConditionOperator

Remarks

For an icon set conditional formatting rule, this property can be set to only one of the following two constants: xlGreater or xlGreaterEqual.

Type

Returns one of the constants of the ConditionValueTypes enumeration, which specifies how the threshold value for an icon set is determined.

ConditionValueTypes Type { get; set; }

Property Value

ConditionValueTypes

Value

Returns or sets the threshold value for an icon in a conditional format (read or write variant).

object Value { get; set; }

Property Value

object