FormatConditionCollection
Overview
FormatConditionCollection is a class in Aspose.Cells for NET.
FormatConditionCollection.Add adds a conditional format for the specified area with type, operator and formulas.
Properties
| Name | Type | Access | Description |
|---|---|---|---|
Count | int | Read | Gets the total number of conditions in the collection |
RangeCount | int | Read | Gets the number of distinct cell areas in the collection |
Methods
| Signature | Description |
|---|---|
Add(area: CellArea, type: FormatConditionType, operatorType: OperatorType, formula1: string, formula2: string) | Adds a conditional format for the specified area with type, operator and formulas |
AddCondition(type: FormatConditionType) | Adds a new condition with the specified type using default operator and empty formulas |
AddCondition(type: FormatConditionType, operatorType: OperatorType, formula1: string, formula2: string) | |
AddArea(area: CellArea) | Adds the specified CellArea to the collection’s range list |
GetCellArea(index: int) | Returns the CellArea at the given index |
RemoveArea(index: int) | Removes the cell area at the specified zero-based index |
RemoveArea(startRow: int, startColumn: int, totalRows: int, totalColumns: int) | |
RemoveCondition(index: int) | Deletes the condition at the given index |