asposecells.api

Class PivotFilter

Represents a PivotFilter in PivotFilter Collection.

Property Getters/Setters Summary
methodgetAutoFilter()
Gets the autofilter of the pivot filter.
methodgetEvaluationOrder()
method
           Gets the Evaluation Order of the pivot filter.
methodgetFieldIndex()
Gets the field index of the pivot filter.
methodgetFilterCategory()
The value of the property is FilterCategory integer constant.
methodgetFilterType()
Gets the autofilter type of the pivot filter. The value of the property is PivotFilterType integer constant.
methodgetMeasureCubeFieldIndex()
methodgetMeasureFldIndex()
method
           Gets the measure field index of the pivot filter.
methodgetMemberPropertyFieldIndex()
method
           Gets the member property field index of the pivot filter.
methodgetName()
method
setName(value)
           Gets the name of the pivot filter.
methodgetUseWholeDay()
method
          
methodgetValue1()
method
setValue1(value)
           Gets the string value1 of the label pivot filter.
methodgetValue2()
method
setValue2(value)
           Gets the string value2 of the label pivot filter.
methodgetValueFieldIndex()
method
          
 
Method Summary
methodgetDateTimeValues()
methodgetLabels()
methodgetNumberValues()
methodgetTop10Value()
 

    • Property Getters/Setters Detail

      • getUseWholeDay/setUseWholeDay : boolean 

        boolean getUseWholeDay() / setUseWholeDay(value)
        
      • getFilterType : int 

        int getFilterType()
        
        Gets the autofilter type of the pivot filter. The value of the property is PivotFilterType integer constant.
      • getFieldIndex : int 

        int getFieldIndex()
        
        Gets the field index of the pivot filter.
      • getFilterCategory : int 

        int getFilterCategory()
        
        The value of the property is FilterCategory integer constant.
      • getValue1/setValue1 : String 

        String getValue1() / setValue1(value)
        
        Gets the string value1 of the label pivot filter.
      • getValue2/setValue2 : String 

        String getValue2() / setValue2(value)
        
        Gets the string value2 of the label pivot filter.
      • getMeasureFldIndex/setMeasureFldIndex : int 

        int getMeasureFldIndex() / setMeasureFldIndex(value)
        
        Gets the measure field index of the pivot filter.
      • getValueFieldIndex/setValueFieldIndex : int 

        int getValueFieldIndex() / setValueFieldIndex(value)
        
      • getMeasureCubeFieldIndex : int 

        int getMeasureCubeFieldIndex()
        
      • getMemberPropertyFieldIndex/setMemberPropertyFieldIndex : int 

        int getMemberPropertyFieldIndex() / setMemberPropertyFieldIndex(value)
        
        Gets the member property field index of the pivot filter.
      • getName/setName : String 

        String getName() / setName(value)
        
        Gets the name of the pivot filter.
      • getEvaluationOrder/setEvaluationOrder : int 

        int getEvaluationOrder() / setEvaluationOrder(value)
        
        Gets the Evaluation Order of the pivot filter.
    • Method Detail

      • getLabels

        String[] getLabels()
      • getNumberValues

        double[] getNumberValues()
      • getDateTimeValues

        DateTime[] getDateTimeValues()