PivotFilterValues Enum
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
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". |