FormatConditionCollection
Overview
FormatConditionCollection is a class in Aspose.Cells FOSS for Java.
Represents a collection of format conditions in Excel.
This class provides 9 methods for working with FormatConditionCollection objects in Java programs.
Available methods include: add, addArea, addCondition, get, getCellArea, getCount, getRangeCount, removeArea, removeCondition.
All exported members are accessible to any Java application after installing the Aspose.Cells FOSS for Java package.
Properties: count, rangeCount.
Properties
| Name | Type | Access | Description |
|---|---|---|---|
count | int | Read | Returns the count. |
rangeCount | int | Read | Returns the range count. |
Methods
| Signature | Description |
|---|---|
getCount() → int | Returns the count. |
getRangeCount() → int | Returns the range count. |
get(index: int) → FormatCondition | Returns the requested item. |
add(area: CellArea, type: FormatConditionType, operatorType: OperatorType, formula1: String, formula2: String) → int | Adds a new item to the current collection. |
addCondition(type: FormatConditionType) → int | Adds condition. |
addCondition(type: FormatConditionType, operatorType: OperatorType, formula1: String, formula2: String) → int | Adds condition. |
addArea(area: CellArea) | Adds area. |
getCellArea(index: int) → CellArea | Processes get cell area. |
removeArea(index: int) | Removes area. |
removeArea(startRow: int, startColumn: int, totalRows: int, totalColumns: int) | Removes area. |
removeCondition(index: int) | Removes condition. |