aspose.cells

Classes

Constants

Class PivotFilter

Represents a PivotFilter in PivotFilter Collection.

Property Getters/Setters Summary
`function`	`getAutoFilter()`
	Gets the autofilter of the pivot filter.
`function`	`getEvaluationOrder()`
`function`	`setEvaluationOrder(value)`
	Gets the Evaluation Order of the pivot filter.
`function`	`getFieldIndex()`
	Gets the field index of the pivot filter.
`function`	`getFilterType()`
	Gets the autofilter type of the pivot filter. The value of the property is PivotFilterType integer constant.
`function`	`getMeasureFldIndex()`
`function`	`setMeasureFldIndex(value)`
	Gets the measure field index of the pivot filter.
`function`	`getMemberPropertyFieldIndex()`
`function`	`setMemberPropertyFieldIndex(value)`
	Gets the member property field index of the pivot filter.
`function`	`getName()`
`function`	`setName(value)`
	Gets the name of the pivot filter.
`function`	`getValue1()`
`function`	`setValue1(value)`
	Gets the string value1 of the label pivot filter.
`function`	`getValue2()`
`function`	`setValue2(value)`
	Gets the string value2 of the label pivot filter.

- Property Getters/Setters Detail
  - getAutoFilter : AutoFilter
```
function getAutoFilter()
```
    Gets the autofilter of the pivot filter.
  - getFilterType : Number
```
function getFilterType()
```
    Gets the autofilter type of the pivot filter. The value of the property is PivotFilterType integer constant.
  - getFieldIndex : Number
```
function getFieldIndex()
```
    Gets the field index of the pivot filter.
  - getValue1/setValue1 : String
```
function getValue1() / function setValue1(value)
```
    Gets the string value1 of the label pivot filter.
  - getValue2/setValue2 : String
```
function getValue2() / function setValue2(value)
```
    Gets the string value2 of the label pivot filter.
  - getMeasureFldIndex/setMeasureFldIndex : Number
```
function getMeasureFldIndex() / function setMeasureFldIndex(value)
```
    Gets the measure field index of the pivot filter.
  - getMemberPropertyFieldIndex/setMemberPropertyFieldIndex : Number
```
function getMemberPropertyFieldIndex() / function setMemberPropertyFieldIndex(value)
```
    Gets the member property field index of the pivot filter.
  - getName/setName : String
```
function getName() / function setName(value)
```
    Gets the name of the pivot filter.
  - getEvaluationOrder/setEvaluationOrder : Number
```
function getEvaluationOrder() / function setEvaluationOrder(value)
```
    Gets the Evaluation Order of the pivot filter.