Class PivotFilterCollection

Represents a collection of advanced filters for a PivotTable.

Inheritance

object

PivotFilterCollection

Implements

IEnumerable<PivotTableAdvancedFilter>

IEnumerable

Inherited Members

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Namespace: DRIT.Spreadsheet.Pivot

Assembly: DRIT.Spreadsheet.dll

Syntax

public class PivotFilterCollection : IEnumerable<PivotTableAdvancedFilter>, IEnumerable

Properties

Count

Gets the number of filters in this collection.

Declaration

public int Count { get; }

Property Value

Type	Description
int

PivotTable

Gets the parent pivot table for this filter collection.

Declaration

public PivotTable PivotTable { get; }

Property Value

Type	Description
PivotTable

Methods

Add(PivotTableAdvancedFilter)

Adds a pivot table advanced filter to the collection.

Declaration

public void Add(PivotTableAdvancedFilter item)

Parameters

Type	Name	Description
PivotTableAdvancedFilter	item	The filter to add.

Clear()

Removes all filters from the collection.

Declaration

public void Clear()

GetEnumerator()

Returns an enumerator for iterating over the filters in this collection.

Declaration

public IEnumerator<PivotTableAdvancedFilter> GetEnumerator()

Returns

Type	Description
IEnumerator<PivotTableAdvancedFilter>	An enumerator for the filters.

Remove(PivotTableAdvancedFilter)

Removes the specified filter from the collection.

Declaration

public bool Remove(PivotTableAdvancedFilter item)

Parameters

Type	Name	Description
PivotTableAdvancedFilter	item	The filter to remove.

Returns

Type	Description
bool	true if the filter was removed; otherwise, false.

Implements

IEnumerable<T>

IEnumerable