GrapeCity.Documents.Excel.ITop10.NumberFormat

NumberFormat Property

NumberFormat

Gets or sets the number format applied to a cell if the conditional formatting rule evaluates to true.

The returned string uses an Excel-style number format pattern for this top or bottom N conditional formatting rule.

Declaration

string NumberFormat { get; set; }

Property NumberFormat As String

Examples

worksheet.Range["A1:A5"].Value = new object[,] {{10}, {30}, {20}, {50}, {40}};
ITop10 top10 = worksheet.Range["A1:A5"].FormatConditions.AddTop10();
top10.Interior.Color = Color.Yellow;
top10.Rank = 2;
top10.NumberFormat = "0.00";
string numberFormat = top10.NumberFormat;