PivotFormatConditionCollection

PivotFormatConditionCollection class

Represents PivotTable Format Conditions.

class PivotFormatConditionCollection;

Remarks

NOTE: This method is now obsolete. Instead, please use PivotConditionalFormatCollection class. This method will be removed 12 months later since December 2024. Aspose apologizes for any inconvenience you may have experienced.

Properties

PropertyTypeDescription
countnumberReadonly. Gets the count of conditional formats.

Methods

MethodDescription
get(number)Gets the pivot FormatCondition object at the specific index.
add()Adds a pivot FormatCondition to the collection.
removeAt(number)Remove a conditional formats.

count

Readonly. Gets the count of conditional formats.

count : number;

get(number)

Gets the pivot FormatCondition object at the specific index.

get(index: number) : PivotFormatCondition;

Parameters:

ParameterTypeDescription
indexnumber

Returns

pivot FormatCondition object.

add()

Adds a pivot FormatCondition to the collection.

add() : number;

Returns

pivot FormatCondition object index.

Remarks

not supported

removeAt(number)

Remove a conditional formats.

removeAt(index: number) : void;

Parameters:

ParameterTypeDescription
indexnumber