GrapeCity.Documents.Excel.PivotFilterOptions

Class PivotFilterOptions

Namespace

GrapeCity.Documents.Excel

Assembly

GcDocs.Excel.dll

Represents optional settings for pivot filters, containing special settings for value filters, date filters, and top 10 filters.

public class PivotFilterOptions

Inheritance

object

PivotFilterOptions

Inherited Members

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Constructors

PivotFilterOptions()

public PivotFilterOptions()

Properties

AppliedDataField

Gets or sets the value filter setting. Specifies which DataField the current field is filtered by. The value represents the index of the referenced DataField in the DataFields collection.

public int AppliedDataField { get; set; }

Property Value

int

Description

Gets or sets a brief description of the filter.

public string Description { get; set; }

Property Value

string

IsTop10Type

Gets or sets a value indicating the selection direction of the 'top 10 filter'. 'True' means selecting the top n items, and 'false' means selecting the bottom n items. The default value is 'true'.

public bool IsTop10Type { get; set; }

Property Value

bool

Name

Gets or sets the name of the filter.

public string Name { get; set; }

Property Value

string

WholeDayFilter

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

public bool WholeDayFilter { get; set; }

Property Value

bool