PivotFormatCondition
Source: aspose.
Represents a PivotTable Format Condition in PivotFormatCondition Collection.
Methods
Methods
addColumnAreaCondition(fieldName)
Adds PivotTable conditional format limit in the column fields.
Parameter
| Name | Type | Optional | Description |
|---|---|---|---|
|
fieldName |
String |
|
The name of PivotField. |
addColumnAreaCondition(columnField)
Adds PivotTable conditional format limit in the column fields.
Parameter
| Name | Type | Optional | Description |
|---|---|---|---|
|
columnField |
|
The PivotField in the column fields. |
addDataAreaCondition(fieldName)
Adds PivotTable conditional format limit in the data fields.
Parameter
| Name | Type | Optional | Description |
|---|---|---|---|
|
fieldName |
String |
|
The name of PivotField. |
addDataAreaCondition(dataField)
Adds PivotTable conditional format limit in the data fields.
Parameter
| Name | Type | Optional | Description |
|---|---|---|---|
|
dataField |
|
The PivotField in the data fields. |
addRowAreaCondition(fieldName)
Adds PivotTable conditional format limit in the row fields.
Parameter
| Name | Type | Optional | Description |
|---|---|---|---|
|
fieldName |
String |
|
The name of PivotField. |
addRowAreaCondition(rowField)
Adds PivotTable conditional format limit in the row fields.
Parameter
| Name | Type | Optional | Description |
|---|---|---|---|
|
rowField |
|
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.