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.
Description
FormatConditionCollection is a class in the Aspose.Cells FOSS library for Java that exposes 11 methods and 2 properties for programmatic use.
Core capabilities include: Adds area; removes area; removes condition. These operations enable developers to integrate formatconditioncollection functionality directly into Java applications.
The class also provides the count property (returns the count), the rangeCount property (returns the range count).
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. |
