Get Started

API Reference

Enum

ExcelPivotFilterType

Edit on GitHub
Namespace OfficeIMO.Excel
Assembly OfficeIMO.Excel
Source OfficeIMO.Excel/ExcelChartSnapshot.cs:70
Base Enum
Implements
IComparable ISpanFormattable IFormattable IConvertible
Modifiers sealed

Defines OfficeIMO values corresponding to DocumentFormat.OpenXml.Spreadsheet.PivotFilterValues.

Inheritance

  • Enum
  • ExcelPivotFilterType

Usage

This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.

Returned or exposed by

Accepted by parameters

Values

public const ExcelPivotFilterType Unknown #

Represents the Open XML value unknown.

Value: 0
public const ExcelPivotFilterType Count #

Represents the Open XML value count.

Value: 1
public const ExcelPivotFilterType Percent #

Represents the Open XML value percent.

Value: 2
public const ExcelPivotFilterType Sum #

Represents the Open XML value sum.

Value: 3
public const ExcelPivotFilterType CaptionEqual #

Represents the Open XML value captionEqual.

Value: 4
public const ExcelPivotFilterType CaptionNotEqual #

Represents the Open XML value captionNotEqual.

Value: 5
public const ExcelPivotFilterType CaptionBeginsWith #

Represents the Open XML value captionBeginsWith.

Value: 6
public const ExcelPivotFilterType CaptionNotBeginsWith #

Represents the Open XML value captionNotBeginsWith.

Value: 7
public const ExcelPivotFilterType CaptionEndsWith #

Represents the Open XML value captionEndsWith.

Value: 8
public const ExcelPivotFilterType CaptionNotEndsWith #

Represents the Open XML value captionNotEndsWith.

Value: 9
public const ExcelPivotFilterType CaptionContains #

Represents the Open XML value captionContains.

Value: 10
public const ExcelPivotFilterType CaptionNotContains #

Represents the Open XML value captionNotContains.

Value: 11
public const ExcelPivotFilterType CaptionGreaterThan #

Represents the Open XML value captionGreaterThan.

Value: 12
public const ExcelPivotFilterType CaptionGreaterThanOrEqual #

Represents the Open XML value captionGreaterThanOrEqual.

Value: 13
public const ExcelPivotFilterType CaptionLessThan #

Represents the Open XML value captionLessThan.

Value: 14
public const ExcelPivotFilterType CaptionLessThanOrEqual #

Represents the Open XML value captionLessThanOrEqual.

Value: 15
public const ExcelPivotFilterType CaptionBetween #

Represents the Open XML value captionBetween.

Value: 16
public const ExcelPivotFilterType CaptionNotBetween #

Represents the Open XML value captionNotBetween.

Value: 17
public const ExcelPivotFilterType ValueEqual #

Represents the Open XML value valueEqual.

Value: 18
public const ExcelPivotFilterType ValueNotEqual #

Represents the Open XML value valueNotEqual.

Value: 19
public const ExcelPivotFilterType ValueGreaterThan #

Represents the Open XML value valueGreaterThan.

Value: 20
public const ExcelPivotFilterType ValueGreaterThanOrEqual #

Represents the Open XML value valueGreaterThanOrEqual.

Value: 21
public const ExcelPivotFilterType ValueLessThan #

Represents the Open XML value valueLessThan.

Value: 22
public const ExcelPivotFilterType ValueLessThanOrEqual #

Represents the Open XML value valueLessThanOrEqual.

Value: 23
public const ExcelPivotFilterType ValueBetween #

Represents the Open XML value valueBetween.

Value: 24
public const ExcelPivotFilterType ValueNotBetween #

Represents the Open XML value valueNotBetween.

Value: 25
public const ExcelPivotFilterType DateEqual #

Represents the Open XML value dateEqual.

Value: 26
public const ExcelPivotFilterType DateNotEqual #

Represents the Open XML value dateNotEqual.

Value: 27
public const ExcelPivotFilterType DateOlderThan #

Represents the Open XML value dateOlderThan.

Value: 28
public const ExcelPivotFilterType DateOlderThanOrEqual #

Represents the Open XML value dateOlderThanOrEqual.

Value: 29
public const ExcelPivotFilterType DateNewerThan #

Represents the Open XML value dateNewerThan.

Value: 30
public const ExcelPivotFilterType DateNewerThanOrEqual #

Represents the Open XML value dateNewerThanOrEqual.

Value: 31
public const ExcelPivotFilterType DateBetween #

Represents the Open XML value dateBetween.

Value: 32
public const ExcelPivotFilterType DateNotBetween #

Represents the Open XML value dateNotBetween.

Value: 33
public const ExcelPivotFilterType Tomorrow #

Represents the Open XML value tomorrow.

Value: 34
public const ExcelPivotFilterType Today #

Represents the Open XML value today.

Value: 35
public const ExcelPivotFilterType Yesterday #

Represents the Open XML value yesterday.

Value: 36
public const ExcelPivotFilterType NextWeek #

Represents the Open XML value nextWeek.

Value: 37
public const ExcelPivotFilterType ThisWeek #

Represents the Open XML value thisWeek.

Value: 38
public const ExcelPivotFilterType LastWeek #

Represents the Open XML value lastWeek.

Value: 39
public const ExcelPivotFilterType NextMonth #

Represents the Open XML value nextMonth.

Value: 40
public const ExcelPivotFilterType ThisMonth #

Represents the Open XML value thisMonth.

Value: 41
public const ExcelPivotFilterType LastMonth #

Represents the Open XML value lastMonth.

Value: 42
public const ExcelPivotFilterType NextQuarter #

Represents the Open XML value nextQuarter.

Value: 43
public const ExcelPivotFilterType ThisQuarter #

Represents the Open XML value thisQuarter.

Value: 44
public const ExcelPivotFilterType LastQuarter #

Represents the Open XML value lastQuarter.

Value: 45
public const ExcelPivotFilterType NextYear #

Represents the Open XML value nextYear.

Value: 46
public const ExcelPivotFilterType ThisYear #

Represents the Open XML value thisYear.

Value: 47
public const ExcelPivotFilterType LastYear #

Represents the Open XML value lastYear.

Value: 48
public const ExcelPivotFilterType YearToDate #

Represents the Open XML value yearToDate.

Value: 49
public const ExcelPivotFilterType Quarter1 #

Represents the Open XML value Q1.

Value: 50
public const ExcelPivotFilterType Quarter2 #

Represents the Open XML value Q2.

Value: 51
public const ExcelPivotFilterType Quarter3 #

Represents the Open XML value Q3.

Value: 52
public const ExcelPivotFilterType Quarter4 #

Represents the Open XML value Q4.

Value: 53
public const ExcelPivotFilterType January #

Represents the Open XML value M1.

Value: 54
public const ExcelPivotFilterType February #

Represents the Open XML value M2.

Value: 55
public const ExcelPivotFilterType March #

Represents the Open XML value M3.

Value: 56
public const ExcelPivotFilterType April #

Represents the Open XML value M4.

Value: 57
public const ExcelPivotFilterType May #

Represents the Open XML value M5.

Value: 58
public const ExcelPivotFilterType June #

Represents the Open XML value M6.

Value: 59
public const ExcelPivotFilterType July #

Represents the Open XML value M7.

Value: 60
public const ExcelPivotFilterType August #

Represents the Open XML value M8.

Value: 61
public const ExcelPivotFilterType September #

Represents the Open XML value M9.

Value: 62
public const ExcelPivotFilterType October #

Represents the Open XML value M10.

Value: 63
public const ExcelPivotFilterType November #

Represents the Open XML value M11.

Value: 64
public const ExcelPivotFilterType December #

Represents the Open XML value M12.

Value: 65