aspose.cells

Class PivotFilter

Represents a PivotFilter in PivotFilter Collection.

Property Getters/Setters Summary
functiongetAutoFilter()
Gets the autofilter of the pivot filter.
functiongetEvaluationOrder()
function
           Gets the Evaluation Order of the pivot filter.
functiongetFieldIndex()
Gets the field index of the pivot filter.
functiongetFilterType()
Gets the autofilter type of the pivot filter. The value of the property is PivotFilterType integer constant.
functiongetMeasureFldIndex()
function
           Gets the measure field index of the pivot filter.
functiongetMemberPropertyFieldIndex()
function
           Gets the member property field index of the pivot filter.
functiongetName()
function
setName(value)
           Gets the name of the pivot filter.
functiongetValue1()
function
setValue1(value)
           Gets the string value1 of the label pivot filter.
functiongetValue2()
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.