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.
new Top10()
Methods
| Name | Description |
|---|---|
| getRank() | Get or set the value of “n” in a “top/bottom n” conditional formatting rule. If IsPercent is true, the value must betwee |
| isBottom() | Get or set whether a “top/bottom n” rule is a “bottom n” rule. Default value is false. |
| isPercent() | Get or set whether a “top/bottom n” rule is a “top/bottom n percent” rule. Default value is false. |
| setBottom() | Get or set whether a “top/bottom n” rule is a “bottom n” rule. Default value is false. |
| setPercent() | Get or set 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 betwee |
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 whether a “top/bottom n” rule is a “bottom n” rule. Default value is false.
isPercent()
Get or set whether a “top/bottom n” rule is a “top/bottom n percent” rule. Default value is false.
setBottom()
Get or set whether a “top/bottom n” rule is a “bottom n” rule. Default value is false.
setPercent()
Get or set 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.