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