Class PivotFilterType

Pivot filter type

Inheritance

System.Object

PivotFilterType

Namespace: Syncfusion.XlsIO

Assembly: Syncfusion.XlsIO.Portable.dll

Syntax

public sealed class PivotFilterType : Enum

Fields

CaptionBeginsWith

Indicates the "begins with" filter for field captions.

Declaration

public const PivotFilterType CaptionBeginsWith

Field Value

Type	Description
PivotFilterType

CaptionBetween

Indicates the "is between" filter for field captions.

Declaration

public const PivotFilterType CaptionBetween

Field Value

Type	Description
PivotFilterType

CaptionContains

Indicates the "contains" filter for field captions.

Declaration

public const PivotFilterType CaptionContains

Field Value

Type	Description
PivotFilterType

CaptionEndsWith

Indicates the "ends with" filter for field captions.

Declaration

public const PivotFilterType CaptionEndsWith

Field Value

Type	Description
PivotFilterType

CaptionEqual

Indicates the "equal" filter for field captions.

Declaration

public const PivotFilterType CaptionEqual

Field Value

Type	Description
PivotFilterType

CaptionGreaterThan

Indicates the "is greater than" filter for field captions

Declaration

public const PivotFilterType CaptionGreaterThan

Field Value

Type	Description
PivotFilterType

CaptionGreaterThanOrEqual

Indicates the "is greater than or equal to" filter for field captions.

Declaration

public const PivotFilterType CaptionGreaterThanOrEqual

Field Value

Type	Description
PivotFilterType

CaptionLessThan

Indicates the "is less than" filter for field captions.

Declaration

public const PivotFilterType CaptionLessThan

Field Value

Type	Description
PivotFilterType

CaptionLessThanOrEqual

Indicates the "is less than or equal to" filter for field captions.

Declaration

public const PivotFilterType CaptionLessThanOrEqual

Field Value

Type	Description
PivotFilterType

CaptionNotBeginsWith

Indicates the "does not begin with" filter for field captions.

Declaration

public const PivotFilterType CaptionNotBeginsWith

Field Value

Type	Description
PivotFilterType

CaptionNotBetween

Indicates the "is not between" filter for field captions.

Declaration

public const PivotFilterType CaptionNotBetween

Field Value

Type	Description
PivotFilterType

CaptionNotContains

Indicates the "does not contain" filter for field captions.

Declaration

public const PivotFilterType CaptionNotContains

Field Value

Type	Description
PivotFilterType

CaptionNotEndsWith

Indicates the "does not end with" filter for field captions.

Declaration

public const PivotFilterType CaptionNotEndsWith

Field Value

Type	Description
PivotFilterType

CaptionNotEqual

Indicates the "not equal" filter for field captions.

Declaration

public const PivotFilterType CaptionNotEqual

Field Value

Type	Description
PivotFilterType

Count

Indicates the "count" filter.

Declaration

public const PivotFilterType Count

Field Value

Type	Description
PivotFilterType

DateBetween

Indicates the "dateBetween" filter.

Declaration

public const PivotFilterType DateBetween

Field Value

Type	Description
PivotFilterType

DateEqual

Indicates the "dateEqual" filter.

Declaration

public const PivotFilterType DateEqual

Field Value

Type	Description
PivotFilterType

dateNewerThan

Indicates the "dateNewerThan" filter.

Declaration

public const PivotFilterType dateNewerThan

Field Value

Type	Description
PivotFilterType

DateNewerThanOrEqual

Indicates the "dateNewerThanOrEqual" filter.

Declaration

public const PivotFilterType DateNewerThanOrEqual

Field Value

Type	Description
PivotFilterType

DateNotBetween

Indicates the "dateNotBetween" filter.

Declaration

public const PivotFilterType DateNotBetween

Field Value

Type	Description
PivotFilterType

DateNotEqual

Indicates the "dateNotEqual" filter.

Declaration

public const PivotFilterType DateNotEqual

Field Value

Type	Description
PivotFilterType

DateOlderThan

Indicates the "dateOlderThan" filter.

Declaration

public const PivotFilterType DateOlderThan

Field Value

Type	Description
PivotFilterType

DateOlderThanOrEqual

Indicates the "dateOlderThanOrEqual" filter.

Declaration

public const PivotFilterType DateOlderThanOrEqual

Field Value

Type	Description
PivotFilterType

LastMonth

Indicates the "lastMonth" filter.

Declaration

public const PivotFilterType LastMonth

Field Value

Type	Description
PivotFilterType

LastQuarter

Indicates the "lastQuarter" filter.

Declaration

public const PivotFilterType LastQuarter

Field Value

Type	Description
PivotFilterType

LastWeek

Indicates the "lastWeek" filter.

Declaration

public const PivotFilterType LastWeek

Field Value

Type	Description
PivotFilterType

LastYear

Indicates the "lastYear" filter.

Declaration

public const PivotFilterType LastYear

Field Value

Type	Description
PivotFilterType

M1

Indicates the "M1" filter.

Declaration

public const PivotFilterType M1

Field Value

Type	Description
PivotFilterType

M10

Indicates the "M10" filter.

Declaration

public const PivotFilterType M10

Field Value

Type	Description
PivotFilterType

M11

Indicates the "M11" filter.

Declaration

public const PivotFilterType M11

Field Value

Type	Description
PivotFilterType

M12

Indicates the "M12" filter.

Declaration

public const PivotFilterType M12

Field Value

Type	Description
PivotFilterType

M2

Indicates the "M2" filter.

Declaration

public const PivotFilterType M2

Field Value

Type	Description
PivotFilterType

M3

Indicates the "M3" filter.

Declaration

public const PivotFilterType M3

Field Value

Type	Description
PivotFilterType

M4

Indicates the "M4" filter.

Declaration

public const PivotFilterType M4

Field Value

Type	Description
PivotFilterType

M5

Indicates the "M5" filter.

Declaration

public const PivotFilterType M5

Field Value

Type	Description
PivotFilterType

M6

Indicates the "M6" filter.

Declaration

public const PivotFilterType M6

Field Value

Type	Description
PivotFilterType

M7

Indicates the "M7" filter.

Declaration

public const PivotFilterType M7

Field Value

Type	Description
PivotFilterType

M8

Indicates the "M8" filter.

Declaration

public const PivotFilterType M8

Field Value

Type	Description
PivotFilterType

M9

Indicates the "M9" filter.

Declaration

public const PivotFilterType M9

Field Value

Type	Description
PivotFilterType

NextMonth

Indicates the "nextMonth" filter.

Declaration

public const PivotFilterType NextMonth

Field Value

Type	Description
PivotFilterType

NextQuarter

Indicates the "nextQuarter" filter.

Declaration

public const PivotFilterType NextQuarter

Field Value

Type	Description
PivotFilterType

NextYear

Indicates the "nextYear" filter.

Declaration

public const PivotFilterType NextYear

Field Value

Type	Description
PivotFilterType

NexWeek

Indicates the "nextWeek" filter.

Declaration

public const PivotFilterType NexWeek

Field Value

Type	Description
PivotFilterType

Percent

Indicates the "percent" filter.

Declaration

public const PivotFilterType Percent

Field Value

Type	Description
PivotFilterType

Q1

Indicates the "Q1" filter.

Declaration

public const PivotFilterType Q1

Field Value

Type	Description
PivotFilterType

Q2

Indicates the "Q2" filter.

Declaration

public const PivotFilterType Q2

Field Value

Type	Description
PivotFilterType

Q3

Indicates the "Q3" filter.

Declaration

public const PivotFilterType Q3

Field Value

Type	Description
PivotFilterType

Q4

Indicates the "Q4" filter.

Declaration

public const PivotFilterType Q4

Field Value

Type	Description
PivotFilterType

Sum

Indicates the "sum" filter.

Declaration

public const PivotFilterType Sum

Field Value

Type	Description
PivotFilterType

ThisMonth

Indicates the "thisMonth" filter.

Declaration

public const PivotFilterType ThisMonth

Field Value

Type	Description
PivotFilterType

ThisQuarter

Indicates the "thisQuarter" filter.

Declaration

public const PivotFilterType ThisQuarter

Field Value

Type	Description
PivotFilterType

ThisWeek

Indicates the "thisWeek" filter.

Declaration

public const PivotFilterType ThisWeek

Field Value

Type	Description
PivotFilterType

ThisYear

Indicates the "thisYear" filter.

Declaration

public const PivotFilterType ThisYear

Field Value

Type	Description
PivotFilterType

Today

Indicates the "today" filter.

Declaration

public const PivotFilterType Today

Field Value

Type	Description
PivotFilterType

Tomorrow

Indicates the "tomorrow" filter.

Declaration

public const PivotFilterType Tomorrow

Field Value

Type	Description
PivotFilterType

Unknown

Indicates the "unknown" filter.

Declaration

public const PivotFilterType Unknown

Field Value

Type	Description
PivotFilterType

value__

Declaration

public int value__

Field Value

Type	Description
System.Int32

ValueBetween

Indicates the "Value between" filter for text and numeric values.

Declaration

public const PivotFilterType ValueBetween

Field Value

Type	Description
PivotFilterType

ValueEqual

Indicates the "value equal" filter for text and numeric values.

Declaration

public const PivotFilterType ValueEqual

Field Value

Type	Description
PivotFilterType

ValueGreaterThan

Indicates the "value greater than" filter for text and numeric values.

Declaration

public const PivotFilterType ValueGreaterThan

Field Value

Type	Description
PivotFilterType

ValueGreaterThanOrEqual

Indicates the "value greater than or equal to" filter for text and numeric values.

Declaration

public const PivotFilterType ValueGreaterThanOrEqual

Field Value

Type	Description
PivotFilterType

ValueLessThan

Indicates the "value less than" filter for text and numeric values.

Declaration

public const PivotFilterType ValueLessThan

Field Value

Type	Description
PivotFilterType

ValueLessThanOrEqual

Indicates the "value less than or equal to" filter for text and numeric values

Declaration

public const PivotFilterType ValueLessThanOrEqual

Field Value

Type	Description
PivotFilterType

ValueNotBetween

Indicates the "value not between" filter for text and numeric values.

Declaration

public const PivotFilterType ValueNotBetween

Field Value

Type	Description
PivotFilterType

ValueNotEqual

Indicates the "value not equal" filter for text and numeric values.

Declaration

public const PivotFilterType ValueNotEqual

Field Value

Type	Description
PivotFilterType

yearToDate

Indicates the "yearToDate" filter.

Declaration

public const PivotFilterType yearToDate

Field Value

Type	Description
PivotFilterType

Yesterday

Indicates the "yesterday" filter.

Declaration

public const PivotFilterType Yesterday

Field Value

Type	Description
PivotFilterType