![]() |
||
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 | |
---|---|
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. |
int |
getOperator()
Gets the conditional format operator. |
Style |
getStyle()
Gets style of conditional formatted cell range. |
int |
getType()
Gets whether the conditional format is based on a cell value or an expression. |
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 |
setStyle(Style style)
Sets style of conditional formatted cell range. |
void |
setType(int type)
Sets whether the conditional format is based on a cell value or an expression.If type is changed to FormatConditionType.EXPRESSION, operator type would become OperatorType.NONE and fomula2 would be set null automatically. |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Method Detail |
---|
public java.lang.String getFormula1()
ExcelException
- 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.
ExcelException
- if conditonal formattings hava been removed from the sheet.public java.lang.String getFormula2()
ExcelException
- 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.
ExcelException
- if conditonal formattings hava been removed from the sheet.public int getOperator()
ExcelException
- 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.
ExcelException
- if conditonal formattings hava been removed from the sheet.
java.lang.IllegalArgumentException
- if operator type is invalid.OperatorType
public Style getStyle()
ExcelException
- if conditonal formattings hava been removed from the sheet.public void setStyle(Style style)
style
- style of conditional formatted cell range.
ExcelException
- if conditonal formattings hava been removed from the sheet.public int getType()
ExcelException
- if conditonal formattings hava been removed from the sheet.setType(int)
public void setType(int type)
type
- whether the conditional format is based on a cell value or
an expression.It could be one of the following values:
FormatConditionType.CELL_VALUE |
FormatConditionType.EXPRESSION |
java.lang.IllegalArgumentException
- if type of conditional formatting is invalid.
ExcelException
- if conditonal formattings hava been removed from the sheet.
|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |