com.aspose.cells

  • java.lang.Object
    • com.aspose.cells.Top10
public class Top10 
extends java.lang.Object

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.

Constructor Summary
 
Property Getters/Setters Summary
booleanisBottom()
void
setBottom(booleanvalue)
           Get or set the flag indicating whether a "top/bottom n" rule is a "bottom n" rule. '1' indicates 'bottom'. Default value is false.
booleanisPercent()
void
setPercent(booleanvalue)
           Get or set the flag indicating whether a "top/bottom n" rule is a "top/bottom n percent" rule. Default value is false.
intgetRank()
void
setRank(intvalue)
           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.
 

    • Constructor Detail

      • Top10

        public Top10()
    • Property Getters/Setters Detail

      • isPercent/setPercent

        public boolean isPercent() / public void setPercent(boolean value)
        
        Get or set the flag indicating whether a "top/bottom n" rule is a "top/bottom n percent" rule. Default value is false.
      • isBottom/setBottom

        public boolean isBottom() / public void setBottom(boolean value)
        
        Get or set the flag indicating whether a "top/bottom n" rule is a "bottom n" rule. '1' indicates 'bottom'. Default value is false.
      • getRank/setRank

        public int getRank() / public void setRank(int value)
        
        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.

    setPercent

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

    setBottom

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

    setRank

    public voidsetRank(intvalue)
    
    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.