GrapeCity.Documents.Excel.TopBottom

TopBottom Enum

Specifies whether a top 10 conditional formatting rule evaluates the highest values or the lowest values in a series.

Use this enumeration with ITop10 to control whether ranking is evaluated from the top or from the bottom of the applied range.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public enum TopBottom

Public Enum TopBottom

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.TopBottom = TopBottom.Bottom;

Fields

Name	Description
Bottom	Specifies the bottom values.
Top	Specifies the top values.