Get Started

API Reference

Enum

LegacyXlsPivotAggregationFunction

Edit on GitHub
Namespace OfficeIMO.Excel.LegacyXls.Model
Assembly OfficeIMO.Excel
Source OfficeIMO.Excel/ExcelChartUtils.Update.SeriesData.cs:123
Base Enum
Implements
IComparable ISpanFormattable IFormattable IConvertible
Modifiers sealed

Identifies the aggregation function stored in an SXDI PivotTable data item record.

Inheritance

  • Enum
  • LegacyXlsPivotAggregationFunction

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

Values

public const LegacyXlsPivotAggregationFunction Sum #

Sum of values.

Value: 0
public const LegacyXlsPivotAggregationFunction Count #

Count of values.

Value: 1
public const LegacyXlsPivotAggregationFunction Average #

Average of values.

Value: 2
public const LegacyXlsPivotAggregationFunction Max #

Maximum value.

Value: 3
public const LegacyXlsPivotAggregationFunction Min #

Minimum value.

Value: 4
public const LegacyXlsPivotAggregationFunction Product #

Product of values.

Value: 5
public const LegacyXlsPivotAggregationFunction CountNumbers #

Count of numeric values.

Value: 6
public const LegacyXlsPivotAggregationFunction StandardDeviationSample #

Sample standard deviation.

Value: 7
public const LegacyXlsPivotAggregationFunction StandardDeviationPopulation #

Population standard deviation.

Value: 8
public const LegacyXlsPivotAggregationFunction VarianceSample #

Sample variance.

Value: 9
public const LegacyXlsPivotAggregationFunction VariancePopulation #

Population variance.

Value: 10