DataConsolidateFunctionValues enumeration

Office 2013 and later

Data Consolidation Functions

Namespace:  DocumentFormat.OpenXml.Spreadsheet
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

C#
VB
C++
Copy
No code example is currently available or this language may not be supported.

Member nameDescription
Average Average. When the item is serialized out as xml, its value is "average".
Count Count. When the item is serialized out as xml, its value is "count".
CountNumbers CountNums. When the item is serialized out as xml, its value is "countNums".
Maximum Maximum. When the item is serialized out as xml, its value is "max".
Minimum Minimum. 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".
Variance Variance. 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".
Show: