GrapeCity.Documents.Excel.IAboveAverage.NumStdDev

NumStdDev Property

NumStdDev

Gets or sets the numeric standard deviation for an AboveAverage object.

Use this property to get or set the standard deviation value currently assigned to the above average conditional formatting rule.

Declaration

int NumStdDev { get; set; }

Property NumStdDev As Integer

Examples

worksheet.Range["A1:A5"].Value = new object[,] {{10}, {20}, {30}, {40}, {50}};
IAboveAverage format = worksheet.Range["A1:A5"].FormatConditions.AddAboveAverage();
format.Interior.Color = Color.Yellow;
format.NumStdDev = 2;
int numStdDev = format.NumStdDev;