GrapeCity.Documents.Excel.IIconCriterion.Type

Type Property

Type

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

Use this property to inspect whether the criterion threshold is interpreted as a number, percent, percentile, formula, or another supported condition value type.

Declaration

ConditionValueTypes Type { get; set; }

Property Type As ConditionValueTypes

Examples

IIconSetCondition condition = worksheet.Range["A1:A5"].FormatConditions.AddIconSetCondition();
condition.IconSet = workbook.IconSets[IconSetType.Icon3Symbols];
IIconCriterion criterion = condition.IconCriteria[1];
criterion.Type = ConditionValueTypes.Percent;
ConditionValueTypes type = criterion.Type;