PivotFormatCondition

PivotFormatCondition class

Represents a PivotTable Format Condition in PivotFormatCondition Collection.

Methods

Name	Description
addColumnAreaCondition(fieldName)	Adds PivotTable conditional format limit in the column fields.
addColumnAreaCondition(columnField)	Adds PivotTable conditional format limit in the column fields.
addDataAreaCondition(fieldName)	Adds PivotTable conditional format limit in the data fields.
addDataAreaCondition(dataField)	Adds PivotTable conditional format limit in the data fields.
addRowAreaCondition(fieldName)	Adds PivotTable conditional format limit in the row fields.
addRowAreaCondition(rowField)	Adds PivotTable conditional format limit in the row fields.
getFormatConditions()	Get formatconditions for the pivot table condition format .
getRuleType()	Get and set rule type for the pivot table condition format . The value of the property is PivotConditionFormatRuleType i
getScopeType()	Get and set scope type for the pivot table condition format . The value of the property is PivotConditionFormatScopeType
setConditionalAreas()	Sets conditional areas of PivotFormatCondition object.
setRuleType()	Get and set rule type for the pivot table condition format . The value of the property is PivotConditionFormatRuleType i
setScopeType()	Get and set scope type for the pivot table condition format . The value of the property is PivotConditionFormatScopeType

addColumnAreaCondition(fieldName)

Adds PivotTable conditional format limit in the column fields.

Parameter	Type	Description
fieldName	String	The name of PivotField.

addColumnAreaCondition(columnField)

Adds PivotTable conditional format limit in the column fields.

Parameter	Type	Description
columnField	PivotField	The PivotField in the column fields.

addDataAreaCondition(fieldName)

Adds PivotTable conditional format limit in the data fields.

Parameter	Type	Description
fieldName	String	The name of PivotField.

addDataAreaCondition(dataField)

Adds PivotTable conditional format limit in the data fields.

Parameter	Type	Description
dataField	PivotField	The PivotField in the data fields.

addRowAreaCondition(fieldName)

Adds PivotTable conditional format limit in the row fields.

Parameter	Type	Description
fieldName	String	The name of PivotField.

addRowAreaCondition(rowField)

Adds PivotTable conditional format limit in the row fields.

Parameter	Type	Description
rowField	PivotField	The PivotField in the row fields.

getFormatConditions()

Get formatconditions for the pivot table condition format .

getRuleType()

Get and set rule type for the pivot table condition format . The value of the property is PivotConditionFormatRuleType integer constant.

getScopeType()

Get and set scope type for the pivot table condition format . The value of the property is PivotConditionFormatScopeType integer constant.

setConditionalAreas()

Sets conditional areas of PivotFormatCondition object.

setRuleType()

Get and set rule type for the pivot table condition format . The value of the property is PivotConditionFormatRuleType integer constant.

setScopeType()

Get and set scope type for the pivot table condition format . The value of the property is PivotConditionFormatScopeType integer constant.