GrapeCity.Documents.Excel.IPivotFilter

IPivotFilter Interface

Represents a pivot filter in the PivotFilters collection.

public interface IPivotFilter

Public Interface IPivotFilter

Name	Description
DataField	Gets the data field that the pivot filter depends on.
Description	Gets the description of the pivot filter. The maximum length of the description string is 255 characters.
FilterType	Gets the type of the pivot filter.
Name	Gets the name of the pivot filter.
PivotField	Gets the label field that the pivot filter depends on.
Value1	Gets the first filter value.
Value2	Gets the second filter value.
WholeDayFilter	Gets or sets a value indicating whether the date filter should use whole days in its filtering criteria.

Name	Description
Delete()	Deletes the filter and removes it from the filter collections of the PivotField.