Top10

Top10 class

Describe the Top10 conditional formatting rule. This conditional formatting rule highlights cells whose values fall in the top N or bottom N bracket, as specified.

class Top10;

Constructors

NameDescription
constructor()Default Constructor.

Properties

PropertyTypeDescription
isPercentbooleanGet or set whether a “top/bottom n” rule is a “top/bottom n percent” rule. Default value is false.
isBottombooleanGet or set whether a “top/bottom n” rule is a “bottom n” rule. Default value is false.
ranknumberGet or set the value of “n” in a “top/bottom n” conditional formatting rule. If IsPercent is true, the value must between 0 and 100. Otherwise it must between 0 and 1000. Default value is 10.

constructor()

Default Constructor.

constructor();

isPercent

Get or set whether a “top/bottom n” rule is a “top/bottom n percent” rule. Default value is false.

isPercent : boolean;

isBottom

Get or set whether a “top/bottom n” rule is a “bottom n” rule. Default value is false.

isBottom : boolean;

rank

Get or set the value of “n” in a “top/bottom n” conditional formatting rule. If IsPercent is true, the value must between 0 and 100. Otherwise it must between 0 and 1000. Default value is 10.

rank : number;