![]() |
||
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.FormatConditions
public class FormatConditions
Represents conditional formatting. The FormatConditions can contain up to three conditional formats.
Method Summary | |
---|---|
int |
addArea(CellArea cellArea)
Adds a conditional formatted cell range. |
int[] |
addFormatCondition(CellArea cellArea,
int type,
int operator,
java.lang.String formula1,
java.lang.String formula2)
Adds a formatting condition and effected cell rang to the FormatConditions. |
int |
addFormatCondition(int type,
int operator,
java.lang.String formula1,
java.lang.String formula2)
Adds a formatting condition. |
void |
deleteFormatCondition(int index)
Removes the formatting condition by index. |
FormatCondition |
getFormatCondition(int index)
Gets the formatting conidition by index. |
int |
sizeOfConditionList()
Gets size of formatting conditions. |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Method Detail |
---|
public int[] addFormatCondition(CellArea cellArea, int type, int operator, java.lang.String formula1, java.lang.String formula2)
cellArea
- conditional formatted cell range.type
- type of conditional formatting.It could be one of the members of FormatConditionType.operator
- comparison operator.It could be one of the members of OperatorType.formula1
- the value or expression associated with conditional formatting.formula2
- the value or expression associated with conditional formatting.
ExcelException
- if conditional formattings have bean removed from the sheet.
java.lang.IllegalArgumentException
- if operator type is invalid.
java.lang.IllegalArgumentException
- if type of conditional formatting is invalid.
java.lang.IllegalArgumentException
- if number of formatting conditions is greater than 3.FormatCondition.setType(int)
,
OperatorType
public int addArea(CellArea cellArea)
cellArea
- conditional formatted cell range.
ExcelException
- if conditional formattings have bean removed from the sheet.public int addFormatCondition(int type, int operator, java.lang.String formula1, java.lang.String formula2)
type
- type of conditinal formatting.operator
- comparison operator.formula1
- the value or expression associated with conditinal formatting.formula2
- the value or expression associated with conditinal formatting.
ExcelException
- if conditional formattings have bean removed from the sheet.
java.lang.IllegalArgumentException
- if number of formatting conditions is greater than 3.addFormatCondition(CellArea, int, int, String, String)
public FormatCondition getFormatCondition(int index)
index
- the index of the formatting conidition to return.
ExcelException
- if conditional formattings have bean removed from the sheet.
java.lang.IllegalArgumentException
- if the index is out of range.public int sizeOfConditionList()
public void deleteFormatCondition(int index)
index
- the index of the formatting condition to removed.
ExcelException
- if conditional formattings have bean removed from the sheet.
java.lang.IllegalArgumentException
- if the index is out of range.
|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |