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.
getCount()@deprecated. Please use the ‘count’ property instead. Gets the count of conditional formats.
add()Adds a pivot FormatCondition to the collection.
removeAt(number)Remove a conditional formats.
isNull()Checks whether the implementation object is null.

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.

getCount()

@deprecated. Please use the ‘count’ property instead. Gets the count of conditional formats.

getCount() : number;

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

isNull()

Checks whether the implementation object is null.

isNull() : boolean;