com.spire.xls.core.spreadsheet.conditionalformatting
Class TopBottom

java.lang.Object
  com.spire.xls.core.spreadsheet.conditionalformatting.TopBottom

public class TopBottom
extends java.lang.Object

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

Constructor Summary

TopBottom(Top10 t)

Method Summary

int	getRank() Get or set the value of "n" in a "top/bottom n" conditional formatting rule.
TopBottomType	getType()
void	setRank(int value) Get or set the value of "n" in a "top/bottom n" conditional formatting rule.
void	setType(TopBottomType value)

Constructor Detail

TopBottom

public TopBottom(Top10 t)

Method Detail

getRank

public int getRank()

Get or set the value of "n" in a "top/bottom n" conditional formatting rule. If TopPercent or BottomPercent, the value must between 0 and 100. Otherwise it must between 0 and 1000. Default value is 10.

setRank

public void setRank(int value)

Get or set the value of "n" in a "top/bottom n" conditional formatting rule. If TopPercent or BottomPercent, the value must between 0 and 100. Otherwise it must between 0 and 1000. Default value is 10.

getType

public TopBottomType getType()

setType

public void setType(TopBottomType value)