PivotFormatCondition

PivotFormatCondition class

Represents a PivotTable Format Condition in PivotFormatCondition Collection.

class PivotFormatCondition;

Remarks

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

Properties

PropertyTypeDescription
scopeTypePivotConditionFormatScopeTypeGet and set scope type for the pivot table conditional format .
ruleTypePivotConditionFormatRuleTypeGet and set rule type for the pivot table condition format .
formatConditionsFormatConditionCollectionReadonly. Get conditions for the pivot table conditional format .

Methods

MethodDescription
addDataAreaCondition(string)Adds PivotTable conditional format limit in the data fields.
addDataAreaCondition(PivotField)Adds PivotTable conditional format limit in the data fields.
addRowAreaCondition(string)Adds PivotTable conditional format limit in the row fields.
addRowAreaCondition(PivotField)Adds PivotTable conditional format limit in the row fields.
addColumnAreaCondition(string)Adds PivotTable conditional format limit in the column fields.
addColumnAreaCondition(PivotField)Adds PivotTable conditional format limit in the column fields.
setConditionalAreas()Sets conditional areas of PivotFormatCondition object.

scopeType

Get and set scope type for the pivot table conditional format .

scopeType : PivotConditionFormatScopeType;

ruleType

Get and set rule type for the pivot table condition format .

ruleType : PivotConditionFormatRuleType;

formatConditions

Readonly. Get conditions for the pivot table conditional format .

formatConditions : FormatConditionCollection;

addDataAreaCondition(string)

Adds PivotTable conditional format limit in the data fields.

addDataAreaCondition(fieldName: string) : void;

Parameters:

ParameterTypeDescription
fieldNamestringThe name of PivotField.

addDataAreaCondition(PivotField)

Adds PivotTable conditional format limit in the data fields.

addDataAreaCondition(dataField: PivotField) : void;

Parameters:

ParameterTypeDescription
dataFieldPivotFieldThe PivotField in the data fields.

addRowAreaCondition(string)

Adds PivotTable conditional format limit in the row fields.

addRowAreaCondition(fieldName: string) : void;

Parameters:

ParameterTypeDescription
fieldNamestringThe name of PivotField.

addRowAreaCondition(PivotField)

Adds PivotTable conditional format limit in the row fields.

addRowAreaCondition(rowField: PivotField) : void;

Parameters:

ParameterTypeDescription
rowFieldPivotFieldThe PivotField in the row fields.

addColumnAreaCondition(string)

Adds PivotTable conditional format limit in the column fields.

addColumnAreaCondition(fieldName: string) : void;

Parameters:

ParameterTypeDescription
fieldNamestringThe name of PivotField.

addColumnAreaCondition(PivotField)

Adds PivotTable conditional format limit in the column fields.

addColumnAreaCondition(columnField: PivotField) : void;

Parameters:

ParameterTypeDescription
columnFieldPivotFieldThe PivotField in the column fields.

setConditionalAreas()

Sets conditional areas of PivotFormatCondition object.

setConditionalAreas() : void;