GrapeCity.Documents.Excel.IIconSetCondition.PercentileValues

PercentileValues Property

PercentileValues

Gets or sets a Boolean value indicating if the thresholds for an icon set conditional format are determined by using percentiles.

This property returns false if not every threshold is set to percentile. Use the PercentileValues property to change all threshold types to percentile at once.

Declaration

bool PercentileValues { get; set; }

Property PercentileValues As Boolean

Examples

worksheet.Range["A1:A5"].Value = new object[,] {{10}, {30}, {50}, {70}, {90}};
IIconSetCondition condition = worksheet.Range["A1:A5"].FormatConditions.AddIconSetCondition();
condition.PercentileValues = true;
bool percentileValues = condition.PercentileValues;