asposecells.api

asposecells.api

Class PivotFilterCollection

Represents a collection of all the PivotFilter objects

Property Getters/Setters Summary
methodgetCount()
methodget(index)
Gets the pivotfilter object at the specific index.
 
Method Summary
methodadd(fieldIndex, type)
Adds a PivotFilter Object to the specific type
methodadd(value)
Reserved for internal use.
methodaddDateFilter(baseFieldIndex, type, dateTime1, dateTime2)
methodaddLabelFilter(baseFieldIndex, type, label1, label2)
methodaddTop10Filter(baseFieldIndex, valueFieldIndex, type, isTop, itemCount)
methodaddValueFilter(baseFieldIndex, valueFieldIndex, type, value1, value2)
methodclear()
methodclearFilter(fieldIndex)
Clear PivotFilter from the specific PivotField
methodcontains(value)
Reserved for internal use.
methodget(index)
Reserved for internal use.
methodindexOf(value)
Reserved for internal use.
methoditerator()
methodremoveAt(index)
 

    • Property Getters/Setters Detail

      • getCount : int 

        int getCount()

    • Method Detail

      • add

        int add(fieldIndex, type)
        Adds a PivotFilter Object to the specific type
        Parameters:
        fieldIndex: int - the PivotField index
        type: int - A PivotFilterType value. the PivotFilter type
        Returns:
        the index of the PivotFilter Object in this PivotFilterCollection.

      • addTop10Filter

        PivotFilter addTop10Filter(baseFieldIndex, valueFieldIndex, type, isTop, itemCount)
        Parameters:
        type - A PivotFilterType value.

      • addValueFilter

        PivotFilter addValueFilter(baseFieldIndex, valueFieldIndex, type, value1, value2)
        Parameters:
        type - A PivotFilterType value.

      • clearFilter

         clearFilter(fieldIndex)
        Clear PivotFilter from the specific PivotField
        Parameters:
        fieldIndex: int - the PivotField index

      • clear

         clear()

      • removeAt

         removeAt(index)

      • iterator

        Iterator iterator()

      • get

        Object get(index)
        Reserved for internal use.

      • contains

        boolean contains(value)
        Reserved for internal use.

      • add

        int add(value)
        Reserved for internal use.

      • indexOf

        int indexOf(value)
        Reserved for internal use.