new Top10()

Methods

getRank()

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.

isBottom()

Get or set the flag indicating whether a "top/bottom n" rule is a "bottom n" rule. '1' indicates 'bottom'. Default value is false.

isPercent()

Get or set the flag indicating whether a "top/bottom n" rule is a "top/bottom n percent" rule. Default value is false.

setBottom()

Get or set the flag indicating whether a "top/bottom n" rule is a "bottom n" rule. '1' indicates 'bottom'. Default value is false.

setPercent()

Get or set the flag indicating whether a "top/bottom n" rule is a "top/bottom n percent" rule. Default value is false.

setRank()

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.