Home  Products  Purchase  Downloads  Demos  Forums  Blogs  Ticket  Wiki  API  Corporate


com.aspose.cells
Class Top10

java.lang.Object
  extended by com.aspose.cells.Top10

public class Top10
extends java.lang.Object

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


Constructor Summary
Top10()
           
 
Method Summary
 int getRank()
          Gets the value of "n" in a "top/bottom n" conditional formatting rule.
 boolean isBottom()
          Gets the flag indicating whether a "top/bottom n" rule is a "bottom n" rule.
 boolean isPercent()
          Gets the flag indicating whether a "top/bottom n" rule is a "top/bottom n percent" rule.
 void setBottom(boolean b)
          Sets the flag indicating whether a "top/bottom n" rule is a "bottom n" rule.
 void setPercent(boolean b)
          Sets the flag indicating whether a "top/bottom n" rule is a "top/bottom n percent" rule.
 void setRank(int rank)
          Sets the value of "n" in a "top/bottom n" conditional formatting rule.
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

Top10

public Top10()
Method Detail

isPercent

public boolean isPercent()
Gets the flag indicating whether a "top/bottom n" rule is a "top/bottom n percent" rule. Default value is false.


setPercent

public void setPercent(boolean b)
Sets the flag indicating whether a "top/bottom n" rule is a "top/bottom n percent" rule. Default value is false.

Parameters:
b -

isBottom

public boolean isBottom()
Gets the flag indicating whether a "top/bottom n" rule is a "bottom n" rule. '1' indicates 'bottom'. Default value is false.


setBottom

public void setBottom(boolean b)
Sets the flag indicating whether a "top/bottom n" rule is a "bottom n" rule. '1' indicates 'bottom'. Default value is false.

Parameters:
b -

getRank

public int getRank()
Gets the value of "n" in a "top/bottom n" conditional formatting rule. Default value is 10.


setRank

public void setRank(int rank)
             throws java.lang.IllegalArgumentException
Sets the value of "n" in a "top/bottom n" conditional formatting rule. Default value is 10.

Parameters:
rank - If IsPercent is true, the value must be between 0 and 100. Otherwise it must be between 0 and 1000.
Throws:
java.lang.IllegalArgumentException