Share via


PivotFilterValues Enum

Definition

Pivot Filter Types

public enum PivotFilterValues
public readonly struct PivotFilterValues : DocumentFormat.OpenXml.IEnumValue, DocumentFormat.OpenXml.IEnumValueFactory<DocumentFormat.OpenXml.Spreadsheet.PivotFilterValues>, IEquatable<DocumentFormat.OpenXml.Spreadsheet.PivotFilterValues>
type PivotFilterValues = 
type PivotFilterValues = struct
    interface IEnumValue
    interface IEnumValueFactory<PivotFilterValues>
Public Enum PivotFilterValues
Public Structure PivotFilterValues
Implements IEnumValue, IEnumValueFactory(Of PivotFilterValues), IEquatable(Of PivotFilterValues)
Inheritance
PivotFilterValues
Inheritance
PivotFilterValues

Fields

Name Value Description
Unknown 0

Unknown.

When the item is serialized out as xml, its value is "unknown".

Count 1

Count.

When the item is serialized out as xml, its value is "count".

Percent 2

Percent.

When the item is serialized out as xml, its value is "percent".

Sum 3

Sum.

When the item is serialized out as xml, its value is "sum".

CaptionEqual 4

Caption Equals.

When the item is serialized out as xml, its value is "captionEqual".

CaptionNotEqual 5

Caption Not Equal.

When the item is serialized out as xml, its value is "captionNotEqual".

CaptionBeginsWith 6

Caption Begins With.

When the item is serialized out as xml, its value is "captionBeginsWith".

CaptionNotBeginsWith 7

Caption Does Not Begin With.

When the item is serialized out as xml, its value is "captionNotBeginsWith".

CaptionEndsWith 8

Caption Ends With.

When the item is serialized out as xml, its value is "captionEndsWith".

CaptionNotEndsWith 9

Caption Does Not End With.

When the item is serialized out as xml, its value is "captionNotEndsWith".

CaptionContains 10

Caption Contains.

When the item is serialized out as xml, its value is "captionContains".

CaptionNotContains 11

Caption Does Not Contain.

When the item is serialized out as xml, its value is "captionNotContains".

CaptionGreaterThan 12

Caption Is Greater Than.

When the item is serialized out as xml, its value is "captionGreaterThan".

CaptionGreaterThanOrEqual 13

Caption Is Greater Than Or Equal To.

When the item is serialized out as xml, its value is "captionGreaterThanOrEqual".

CaptionLessThan 14

Caption Is Less Than.

When the item is serialized out as xml, its value is "captionLessThan".

CaptionLessThanOrEqual 15

Caption Is Less Than Or Equal To.

When the item is serialized out as xml, its value is "captionLessThanOrEqual".

CaptionBetween 16

Caption Is Between.

When the item is serialized out as xml, its value is "captionBetween".

CaptionNotBetween 17

Caption Is Not Between.

When the item is serialized out as xml, its value is "captionNotBetween".

ValueEqual 18

Value Equal.

When the item is serialized out as xml, its value is "valueEqual".

ValueNotEqual 19

Value Not Equal.

When the item is serialized out as xml, its value is "valueNotEqual".

ValueGreaterThan 20

Value Greater Than.

When the item is serialized out as xml, its value is "valueGreaterThan".

ValueGreaterThanOrEqual 21

Value Greater Than Or Equal To.

When the item is serialized out as xml, its value is "valueGreaterThanOrEqual".

ValueLessThan 22

Value Less Than.

When the item is serialized out as xml, its value is "valueLessThan".

ValueLessThanOrEqual 23

Value Less Than Or Equal To.

When the item is serialized out as xml, its value is "valueLessThanOrEqual".

ValueBetween 24

Value Between.

When the item is serialized out as xml, its value is "valueBetween".

ValueNotBetween 25

Value Not Between.

When the item is serialized out as xml, its value is "valueNotBetween".

DateEqual 26

Date Equals.

When the item is serialized out as xml, its value is "dateEqual".

DateNotEqual 27

Date Does Not Equal.

When the item is serialized out as xml, its value is "dateNotEqual".

DateOlderThan 28

Date Older Than.

When the item is serialized out as xml, its value is "dateOlderThan".

DateOlderThanOrEqual 29

Date Older Than Or Equal.

When the item is serialized out as xml, its value is "dateOlderThanOrEqual".

DateNewerThan 30

Date Newer Than.

When the item is serialized out as xml, its value is "dateNewerThan".

DateNewerThanOrEqual 31

Date Newer Than or Equal To.

When the item is serialized out as xml, its value is "dateNewerThanOrEqual".

DateBetween 32

Date Between.

When the item is serialized out as xml, its value is "dateBetween".

DateNotBetween 33

Date Not Between.

When the item is serialized out as xml, its value is "dateNotBetween".

Tomorrow 34

Tomorrow.

When the item is serialized out as xml, its value is "tomorrow".

Today 35

Today.

When the item is serialized out as xml, its value is "today".

Yesterday 36

Yesterday.

When the item is serialized out as xml, its value is "yesterday".

NextWeek 37

Next Week.

When the item is serialized out as xml, its value is "nextWeek".

ThisWeek 38

This Week.

When the item is serialized out as xml, its value is "thisWeek".

LastWeek 39

Last Week.

When the item is serialized out as xml, its value is "lastWeek".

NextMonth 40

Next Month.

When the item is serialized out as xml, its value is "nextMonth".

ThisMonth 41

This Month.

When the item is serialized out as xml, its value is "thisMonth".

LastMonth 42

Last Month.

When the item is serialized out as xml, its value is "lastMonth".

NextQuarter 43

Next Quarter.

When the item is serialized out as xml, its value is "nextQuarter".

ThisQuarter 44

This Quarter.

When the item is serialized out as xml, its value is "thisQuarter".

LastQuarter 45

Last Quarter.

When the item is serialized out as xml, its value is "lastQuarter".

NextYear 46

Next Year.

When the item is serialized out as xml, its value is "nextYear".

ThisYear 47

This Year.

When the item is serialized out as xml, its value is "thisYear".

LastYear 48

Last Year.

When the item is serialized out as xml, its value is "lastYear".

YearToDate 49

Year-To-Date.

When the item is serialized out as xml, its value is "yearToDate".

Quarter1 50

First Quarter.

When the item is serialized out as xml, its value is "Q1".

Quarter2 51

Second Quarter.

When the item is serialized out as xml, its value is "Q2".

Quarter3 52

Third Quarter.

When the item is serialized out as xml, its value is "Q3".

Quarter4 53

Fourth Quarter.

When the item is serialized out as xml, its value is "Q4".

January 54

January.

When the item is serialized out as xml, its value is "M1".

February 55

Dates in February.

When the item is serialized out as xml, its value is "M2".

March 56

Dates in March.

When the item is serialized out as xml, its value is "M3".

April 57

Dates in April.

When the item is serialized out as xml, its value is "M4".

May 58

Dates in May.

When the item is serialized out as xml, its value is "M5".

June 59

Dates in June.

When the item is serialized out as xml, its value is "M6".

July 60

Dates in July.

When the item is serialized out as xml, its value is "M7".

August 61

Dates in August.

When the item is serialized out as xml, its value is "M8".

September 62

Dates in September.

When the item is serialized out as xml, its value is "M9".

October 63

Dates in October.

When the item is serialized out as xml, its value is "M10".

November 64

Dates in November.

When the item is serialized out as xml, its value is "M11".

December 65

Dates in December.

When the item is serialized out as xml, its value is "M12".

April

Dates in April.

When the item is serialized out as xml, its value is "M4".

August

Dates in August.

When the item is serialized out as xml, its value is "M8".

CaptionBeginsWith

Caption Begins With.

When the item is serialized out as xml, its value is "captionBeginsWith".

CaptionBetween

Caption Is Between.

When the item is serialized out as xml, its value is "captionBetween".

CaptionContains

Caption Contains.

When the item is serialized out as xml, its value is "captionContains".

CaptionEndsWith

Caption Ends With.

When the item is serialized out as xml, its value is "captionEndsWith".

CaptionEqual

Caption Equals.

When the item is serialized out as xml, its value is "captionEqual".

CaptionGreaterThan

Caption Is Greater Than.

When the item is serialized out as xml, its value is "captionGreaterThan".

CaptionGreaterThanOrEqual

Caption Is Greater Than Or Equal To.

When the item is serialized out as xml, its value is "captionGreaterThanOrEqual".

CaptionLessThan

Caption Is Less Than.

When the item is serialized out as xml, its value is "captionLessThan".

CaptionLessThanOrEqual

Caption Is Less Than Or Equal To.

When the item is serialized out as xml, its value is "captionLessThanOrEqual".

CaptionNotBeginsWith

Caption Does Not Begin With.

When the item is serialized out as xml, its value is "captionNotBeginsWith".

CaptionNotBetween

Caption Is Not Between.

When the item is serialized out as xml, its value is "captionNotBetween".

CaptionNotContains

Caption Does Not Contain.

When the item is serialized out as xml, its value is "captionNotContains".

CaptionNotEndsWith

Caption Does Not End With.

When the item is serialized out as xml, its value is "captionNotEndsWith".

CaptionNotEqual

Caption Not Equal.

When the item is serialized out as xml, its value is "captionNotEqual".

Count

Count.

When the item is serialized out as xml, its value is "count".

DateBetween

Date Between.

When the item is serialized out as xml, its value is "dateBetween".

DateEqual

Date Equals.

When the item is serialized out as xml, its value is "dateEqual".

DateNewerThan

Date Newer Than.

When the item is serialized out as xml, its value is "dateNewerThan".

DateNewerThanOrEqual

Date Newer Than or Equal To.

When the item is serialized out as xml, its value is "dateNewerThanOrEqual".

DateNotBetween

Date Not Between.

When the item is serialized out as xml, its value is "dateNotBetween".

DateNotEqual

Date Does Not Equal.

When the item is serialized out as xml, its value is "dateNotEqual".

DateOlderThan

Date Older Than.

When the item is serialized out as xml, its value is "dateOlderThan".

DateOlderThanOrEqual

Date Older Than Or Equal.

When the item is serialized out as xml, its value is "dateOlderThanOrEqual".

December

Dates in December.

When the item is serialized out as xml, its value is "M12".

Equality(PivotFilterValues, PivotFilterValues)
Equals(Object)
Equals(PivotFilterValues)
February

Dates in February.

When the item is serialized out as xml, its value is "M2".

GetHashCode()
IEnumValue.IsValid
IEnumValue.Value
IEnumValue.Version
IEnumValueFactory<PivotFilterValues>.Create(String)
Inequality(PivotFilterValues, PivotFilterValues)
January

January.

When the item is serialized out as xml, its value is "M1".

July

Dates in July.

When the item is serialized out as xml, its value is "M7".

June

Dates in June.

When the item is serialized out as xml, its value is "M6".

LastMonth

Last Month.

When the item is serialized out as xml, its value is "lastMonth".

LastQuarter

Last Quarter.

When the item is serialized out as xml, its value is "lastQuarter".

LastWeek

Last Week.

When the item is serialized out as xml, its value is "lastWeek".

LastYear

Last Year.

When the item is serialized out as xml, its value is "lastYear".

March

Dates in March.

When the item is serialized out as xml, its value is "M3".

May

Dates in May.

When the item is serialized out as xml, its value is "M5".

NextMonth

Next Month.

When the item is serialized out as xml, its value is "nextMonth".

NextQuarter

Next Quarter.

When the item is serialized out as xml, its value is "nextQuarter".

NextWeek

Next Week.

When the item is serialized out as xml, its value is "nextWeek".

NextYear

Next Year.

When the item is serialized out as xml, its value is "nextYear".

November

Dates in November.

When the item is serialized out as xml, its value is "M11".

October

Dates in October.

When the item is serialized out as xml, its value is "M10".

Percent

Percent.

When the item is serialized out as xml, its value is "percent".

PivotFilterValues(String)

Creates a new PivotFilterValues enum instance

Quarter1

First Quarter.

When the item is serialized out as xml, its value is "Q1".

Quarter2

Second Quarter.

When the item is serialized out as xml, its value is "Q2".

Quarter3

Third Quarter.

When the item is serialized out as xml, its value is "Q3".

Quarter4

Fourth Quarter.

When the item is serialized out as xml, its value is "Q4".

September

Dates in September.

When the item is serialized out as xml, its value is "M9".

Sum

Sum.

When the item is serialized out as xml, its value is "sum".

ThisMonth

This Month.

When the item is serialized out as xml, its value is "thisMonth".

ThisQuarter

This Quarter.

When the item is serialized out as xml, its value is "thisQuarter".

ThisWeek

This Week.

When the item is serialized out as xml, its value is "thisWeek".

ThisYear

This Year.

When the item is serialized out as xml, its value is "thisYear".

Today

Today.

When the item is serialized out as xml, its value is "today".

Tomorrow

Tomorrow.

When the item is serialized out as xml, its value is "tomorrow".

ToString()
Unknown

Unknown.

When the item is serialized out as xml, its value is "unknown".

ValueBetween

Value Between.

When the item is serialized out as xml, its value is "valueBetween".

ValueEqual

Value Equal.

When the item is serialized out as xml, its value is "valueEqual".

ValueGreaterThan

Value Greater Than.

When the item is serialized out as xml, its value is "valueGreaterThan".

ValueGreaterThanOrEqual

Value Greater Than Or Equal To.

When the item is serialized out as xml, its value is "valueGreaterThanOrEqual".

ValueLessThan

Value Less Than.

When the item is serialized out as xml, its value is "valueLessThan".

ValueLessThanOrEqual

Value Less Than Or Equal To.

When the item is serialized out as xml, its value is "valueLessThanOrEqual".

ValueNotBetween

Value Not Between.

When the item is serialized out as xml, its value is "valueNotBetween".

ValueNotEqual

Value Not Equal.

When the item is serialized out as xml, its value is "valueNotEqual".

YearToDate

Year-To-Date.

When the item is serialized out as xml, its value is "yearToDate".

Yesterday

Yesterday.

When the item is serialized out as xml, its value is "yesterday".

Applies to