ConditionalFormattingCollection
Contents
[
Hide
]ConditionalFormattingCollection class
Encapsulates a collection of FormatCondition objects.
class ConditionalFormattingCollection;
Methods
| Method | Description |
|---|---|
| get(number) | Gets the FormatConditions element at the specified index. |
| removeArea(number, number, number, number) | Remove all conditional formatting in the range. |
| copy(ConditionalFormattingCollection) | Copies conditional formatting. |
| add() | Adds a FormatConditions to the collection. |
| getCount() | Gets the number of elements contained in. |
get(number)
Gets the FormatConditions element at the specified index.
get(index: number) : FormatConditionCollection;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| index | number | The zero based index of the element. |
Returns
removeArea(number, number, number, number)
Remove all conditional formatting in the range.
removeArea(startRow: number, startColumn: number, totalRows: number, totalColumns: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| startRow | number | The start row of the range. |
| startColumn | number | The start column of the range. |
| totalRows | number | The number of rows of the range. |
| totalColumns | number | The number of columns of the range. |
copy(ConditionalFormattingCollection)
Copies conditional formatting.
copy(cfs: ConditionalFormattingCollection) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| cfs | ConditionalFormattingCollection | The conditional formatting |
add()
Adds a FormatConditions to the collection.
add() : number;
Returns
FormatConditions object index.
getCount()
Gets the number of elements contained in.
getCount() : number;