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.
Description
FormatConditionCollection is a class in the Aspose.Cells FOSS library for .NET that exposes 8 methods and 2 properties for programmatic use.
The class also provides the Count property (gets the total number of conditions in the collection), the RangeCount property (gets the number of distinct cell areas in the collection).
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 |