Class PivotTableAdvancedFilter

Represents a PivotTable advanced filter.

Inheritance

object

PivotTableAdvancedFilter

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 PivotTableAdvancedFilter

Constructors

PivotTableAdvancedFilter()

Represents a PivotTable advanced filter.

Declaration

public PivotTableAdvancedFilter()

Properties

AutoFilter

Gets the auto filter associated with this pivot table advanced filter.

Declaration

public AutoFilter AutoFilter { get; }

Property Value

Type	Description
AutoFilter

Description

Gets the description of the pivot filter.

Declaration

public string Description { get; }

Property Value

Type	Description
string

EvaluationOrder

Gets the evaluation order of the pivot filter. Zero based.

Declaration

public int EvaluationOrder { get; }

Property Value

Type	Description
int

FieldIndex

Gets the index of the field to which this pivot filter belongs.

Declaration

public int FieldIndex { get; }

Property Value

Type	Description
int

FilterType

Gets the type of pivot filter.

Declaration

public PivotFilterType FilterType { get; }

Property Value

Type	Description
PivotFilterType

MeasureFieldIndex

Gets the index of the measure field. This property is used only by filters in Relational pivots and specifies on which measure a value filter should apply.

Declaration

public int? MeasureFieldIndex { get; }

Property Value

Type	Description
int?

MeasureIndex

Gets the index of the measure cube field. This property is used only by filters in OLAP pivots and specifies on which measure a value filter should apply.

Declaration

public int? MeasureIndex { get; }

Property Value

Type	Description
int?

MemberPropertyFieldId

Gets the index of the field representing the member property field on which this pivot filter is defined. This property is used only by label pivot filters.

Declaration

public int? MemberPropertyFieldId { get; }

Property Value

Type	Description
int?

Name

Gets the name of the pivot filter.

Declaration

public string Name { get; }

Property Value

Type	Description
string

StringValue1

Gets the string value "1" used by label pivot filters.

Declaration

public string StringValue1 { get; }

Property Value

Type	Description
string

StringValue2

Gets the string value "2" used by label pivot filters.

Declaration

public string StringValue2 { get; }

Property Value

Type	Description
string