aspose.cells
Class Top10

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
Top10()
          
 
Property Getters/Setters Summary
functionisBottom()
functionsetBottom(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.
functionisPercent()
functionsetPercent(value)
           Get or set the flag indicating whether a "top/bottom n" rule is a "top/bottom n percent" rule. Default value is false.
functiongetRank()
functionsetRank(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.
 

Constructor Detail

Top10

function Top10()

Property Getters/Setters Detail

isPercent/setPercent : boolean 

function isPercent() / function setPercent(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 : boolean 

function isBottom() / function setBottom(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 : Number 

function getRank() / function setRank(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.

See Also:
          Aspose.Cells Documentation - the home page for the Aspose.Cellss Product Documentation.
          Aspose.Cells Support Forum - our preferred method of support.