ItemValues Enum

Definition

PivotItem Type

C#
public enum ItemValues
C#
public readonly struct ItemValues : DocumentFormat.OpenXml.IEnumValue, DocumentFormat.OpenXml.IEnumValueFactory<DocumentFormat.OpenXml.Spreadsheet.ItemValues>, IEquatable<DocumentFormat.OpenXml.Spreadsheet.ItemValues>
Inheritance
ItemValues
Inheritance
ItemValues

Fields

Name Value Description
Data 0

Data.

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

Default 1

Default.

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

Sum 2

Sum.

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

CountA 3

CountA.

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

Average 4

Average.

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

Maximum 5

Max.

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

Minimum 6

Min.

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

Product 7

Product.

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

Count 8

Count.

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

StandardDeviation 9

stdDev.

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

StandardDeviationP 10

StdDevP.

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

Variance 11

Var.

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

VarianceP 12

VarP.

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

Grand 13

Grand Total Item.

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

Blank 14

Blank Pivot Item.

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

Average

Average.

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

Blank

Blank Pivot Item.

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

Count

Count.

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

CountA

CountA.

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

Data

Data.

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

Default

Default.

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

Equality(ItemValues, ItemValues)
Equals(ItemValues)
Equals(Object)
GetHashCode()
Grand

Grand Total Item.

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

IEnumValue.IsValid
IEnumValue.Value
IEnumValue.Version
IEnumValueFactory<ItemValues>.Create(String)
Inequality(ItemValues, ItemValues)
ItemValues(String)

Creates a new ItemValues enum instance

Maximum

Max.

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

Minimum

Min.

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

Product

Product.

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

StandardDeviation

stdDev.

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

StandardDeviationP

StdDevP.

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

Sum

Sum.

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

ToString()
Variance

Var.

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

VarianceP

VarP.

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

Applies to

Produkt Versiounen
DocumentFormat.OpenXml 2.7.1, 2.7.2, 2.8.0, 2.8.1, 2.9.0, 2.9.1, 2.10.0, 2.10.1, 2.11.0, 2.11.1, 2.11.2, 2.11.3, 2.12.0, 2.12.1, 2.12.2, 2.12.3, 2.13.0, 2.13.1, 2.14.0, 2.15.0, 2.16.0, 2.17.1, 2.18.0, 2.19.0, 2.20.0, 3.0.0, 3.0.1