aspose.cells

Classes

Constants

Class PivotConditionalFormat

Property Getters/Setters Summary
`function`	`getFormatConditions()`

`function`	`getPivotAreas()`

`function`	`getRuleType()`
`function`	`setRuleType(value)`
	The value of the property is PivotConditionFormatRuleType integer constant.
`function`	`getScopeType()`
`function`	`setScopeType(value)`
	The value of the property is PivotConditionFormatScopeType integer constant.

Method Summary
`function`	`addCellArea(ca)`
`function`
`function`	`addFieldArea(axisType, field)`
`function`
`function`	`addFieldArea(axisType, fieldName)`
`function`
`function`	`applyTo(row, column, scope)`
`function`
`function`	`getCellAreas()`
`function`

- Property Getters/Setters Detail
  - getPivotAreas : PivotAreaCollection
```
function getPivotAreas()
```
  - getFormatConditions : FormatConditionCollection
```
function getFormatConditions()
```
  - getScopeType/setScopeType : Number
```
function getScopeType() / function setScopeType(value)
```
    The value of the property is PivotConditionFormatScopeType integer constant.
  - getRuleType/setRuleType : Number
```
function getRuleType() / function setRuleType(value)
```
    The value of the property is PivotConditionFormatRuleType integer constant.
- Method Detail
  - getCellAreas
```
function getCellAreas()
```
  - addCellArea
```
function addCellArea(ca)
```
  - applyTo
```
function applyTo(row, column, scope)
```
    Parameters:
    scope - A PivotConditionFormatScopeType value.
  - addFieldArea
```
function addFieldArea(axisType, fieldName)
```
    Parameters:
    axisType - A PivotFieldType value.
  - addFieldArea
```
function addFieldArea(axisType, field)
```
    Parameters:
    axisType - A PivotFieldType value.