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
| Name | Description |
|---|---|
| constructor() | Default Constructor. |
Methods
| Method | Description |
|---|---|
| isPercent() | Get or set whether a “top/bottom n” rule is a “top/bottom n percent” rule. Default value is false. |
| setIsPercent(boolean) | Get or set whether a “top/bottom n” rule is a “top/bottom n percent” rule. Default value is false. |
| isBottom() | Get or set whether a “top/bottom n” rule is a “bottom n” rule. Default value is false. |
| setIsBottom(boolean) | Get or set whether a “top/bottom n” rule is a “bottom n” rule. Default value is false. |
| 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. |
| setRank(number) | 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. |
| isNull() | Checks whether the implementation object is null. |
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;
setIsPercent(boolean)
Get or set whether a “top/bottom n” rule is a “top/bottom n percent” rule. Default value is false.
setIsPercent(value: boolean) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean | The value to set. |
isBottom()
Get or set whether a “top/bottom n” rule is a “bottom n” rule. Default value is false.
isBottom() : boolean;
setIsBottom(boolean)
Get or set whether a “top/bottom n” rule is a “bottom n” rule. Default value is false.
setIsBottom(value: boolean) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean | The value to set. |
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.
getRank() : number;
setRank(number)
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.
setRank(value: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | number | The value to set. |
isNull()
Checks whether the implementation object is null.
isNull() : boolean;