![]() |
||
Home Products Purchase Downloads Demos Forums Blogs Ticket Wiki API Corporate |
|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectcom.aspose.cells.FormatCondition
public class FormatCondition
Represents conditional formatting condition.
Method Summary | |
---|---|
AboveAverage |
getAboveAverage()
Gets the conditional formatting's "AboveAverage" instance. |
ColorScale |
getColorScale()
Gets the conditional formatting's "ColorScale" instance. |
DataBar |
getDataBar()
Gets the conditional formatting's "DataBar" instance. |
java.lang.String |
getFormula1()
Gets the value or expression associated with conditional formatting. |
java.lang.String |
getFormula2()
Gets the value or expression associated with conditional formatting. |
IconSet |
getIconSet()
Gets the conditional formatting's "IconSet" instance. |
int |
getOperator()
Gets the conditional format operator. |
int |
getPriority()
Gets the priority of this conditional formatting rule. |
Style |
getStyle()
Gets style of conditional formatted cell range. |
java.lang.String |
getText()
Gets the text value in a "text contains" conditional formatting rule. |
byte |
getTimePeriodType()
Gets the applicable time period in a "date occurring" conditional formatting rule. |
Top10 |
getTop10()
Gets the conditional formatting's "Top10" instance. |
int |
getType()
Gets the conditional format's type. |
boolean |
isStopIfTrue()
Checks the "Stop If True" flag. |
void |
setFormula1(java.lang.String formula1)
Sets the value or expression associated with conditional formatting. |
void |
setFormula2(java.lang.String formula2)
Gets the value or expression associated with conditional formatting. |
void |
setOperator(int operator)
Sets the conditional format operator. |
void |
setStopIfTrue(boolean flag)
Sets the "Stop If True" flag. |
void |
setStyle(Style style)
Sets style of conditional formatted cell range. |
void |
setText(java.lang.String text)
Sets the text value in a "text contains" conditional formatting rule. |
void |
setTimePeriodType(byte type)
Sets the applicable time period in a "date occurring� conditional formatting rule. |
void |
setType(int type)
Sets the conditional format's type. |
Methods inherited from class java.lang.Object |
---|
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Method Detail |
---|
public java.lang.String getFormula1()
CellsException
- if conditonal formattings hava been removed from the sheet.public void setFormula1(java.lang.String formula1)
formula1
- the value or expression associated with conditional formatting.
CellsException
- if conditonal formattings hava been removed from the sheet.public java.lang.String getFormula2()
CellsException
- if conditonal formattings hava been removed from the sheet.public void setFormula2(java.lang.String formula2)
formula2
- the value or expression associated with conditional formatting.
CellsException
- if conditonal formattings hava been removed from the sheet.public int getOperator()
CellsException
- if conditonal formattings hava been removed from the sheet.OperatorType
public void setOperator(int operator)
operator
- the conditional format comparison operator type.It could be one of the members of OperatorType.
CellsException
- if conditonal formattings hava been removed from the sheet.
java.lang.IllegalArgumentException
- if operator type is invalid.OperatorType
public Style getStyle()
CellsException
- if conditonal formattings hava been removed from the sheet.public void setStyle(Style style)
style
- style of conditional formatted cell range.
CellsException
- if conditonal formattings hava been removed from the sheet.public int getType()
CellsException
- if conditonal formattings hava been removed from the sheet.setType(int)
public void setType(int type)
type
- It could be one of the following values:
FormatConditionType.CELL_VALUE |
FormatConditionType.EXPRESSION |
FormatConditionType.COLOR_SCALE |
FormatConditionType.DATA_BAR |
FormatConditionType.ICON_SET |
FormatConditionType.TOP_10 |
FormatConditionType.UNIQUE_VALUES |
FormatConditionType.DUPLICATE_VALUES |
FormatConditionType.CONTAINS_TEXT |
FormatConditionType.NOT_CONTAINS_TEXT |
FormatConditionType.BEGINS_WITH |
FormatConditionType.ENDS_WITH |
FormatConditionType.CONTAINS_BLANKS |
FormatConditionType.NOT_CONTAINS_BLANKS |
FormatConditionType.CONTAINS_ERRORS |
FormatConditionType.NOT_CONTAINS_ERRORS |
FormatConditionType.TIME_PERIOD |
FormatConditionType.ABOVE_AVERAGE |
java.lang.IllegalArgumentException
- if type of conditional formatting is invalid.
CellsException
- if conditonal formattings hava been removed from the sheet.public IconSet getIconSet()
public DataBar getDataBar()
public ColorScale getColorScale()
public Top10 getTop10()
public AboveAverage getAboveAverage()
public java.lang.String getText()
public void setText(java.lang.String text)
text
- public byte getTimePeriodType()
public void setTimePeriodType(byte type)
TimePeriodType.TODAY
.
type
- time period typeTimePeriodType
public boolean isStopIfTrue()
public void setStopIfTrue(boolean flag)
flag
- "Stop If True" flag.public int getPriority()
|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |