GrapeCity.Documents.Excel.IPivotFilter

Interface IPivotFilter

Represents a pivot filter in the PivotFilters collection.

public interface IPivotFilter

Gets the data field that the pivot filter depends on.

IPivotField DataField { get; }

Gets the description of the pivot filter. The maximum length of the description string is 255 characters.

string Description { get; }

Gets the type of the pivot filter.

PivotFilterType FilterType { get; }

Gets the name of the pivot filter.

string Name { get; }

Gets the label field that the pivot filter depends on.

IPivotField PivotField { get; }

Gets the first filter value.

object Value1 { get; }

Gets the second filter value.

object Value2 { get; }

Gets or sets a value indicating whether the date filter should use whole days in its filtering criteria.

bool WholeDayFilter { get; set; }

Deletes the filter and removes it from the filter collections of the PivotField.

void Delete()