GrapeCity.Documents.Excel.IConditionValue.Type

Type Property

Type

Returns one of the constants of the ConditionValueTypes enumeration, which specifies how the threshold values for a data bar, color scale, or icon set conditional format are determined.

Use this property to inspect whether the threshold is based on a number, percentage, percentile, formula, or an automatic minimum or maximum value.

Declaration

ConditionValueTypes Type { get; set; }

Property Type As ConditionValueTypes

Examples

worksheet.Range["A1:A3"].Value = new object[,] {{10}, {40}, {90}};
IDataBar dataBar = worksheet.Range["A1:A3"].FormatConditions.AddDatabar();
IConditionValue minPoint = dataBar.MinPoint;
minPoint.Type = ConditionValueTypes.Number;
ConditionValueTypes type = minPoint.Type;