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.
functiongetFilterCategory()
The value of the property is FilterCategory integer constant.
functiongetFilterType()
Gets the autofilter type of the pivot filter. The value of the property is PivotFilterType integer constant.
functiongetMeasureCubeFieldIndex()
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.
functiongetUseWholeDay()
function
          
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.
functiongetValueFieldIndex()
function
          
 
Method Summary
functiongetDateTimeValues()
functiongetLabels()
functiongetNumberValues()
functiongetTop10Value()
 

    • Property Getters/Setters Detail

      • getUseWholeDay/setUseWholeDay : boolean 

        function getUseWholeDay() / function setUseWholeDay(value)
        
      • 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.
      • getFilterCategory : Number 

        function getFilterCategory()
        
        The value of the property is FilterCategory integer constant.
      • 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.
      • getValueFieldIndex/setValueFieldIndex : Number 

        function getValueFieldIndex() / function setValueFieldIndex(value)
        
      • getMeasureCubeFieldIndex : Number 

        function getMeasureCubeFieldIndex()
        
      • 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.
    • Method Detail

      • getTop10Value

        function getTop10Value()
      • getLabels

        function getLabels()
      • getNumberValues

        function getNumberValues()
      • getDateTimeValues

        function getDateTimeValues()