Get Started

API Reference

Enum

LegacyXlsDataConsolidationFunction

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 carried by a BIFF DCon data-consolidation settings record.

Inheritance

  • Enum
  • LegacyXlsDataConsolidationFunction

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 LegacyXlsDataConsolidationFunction Average #

Average source values.

Value: 0
public const LegacyXlsDataConsolidationFunction CountNumbers #

Count numeric source values.

Value: 1
public const LegacyXlsDataConsolidationFunction Count #

Count source values.

Value: 2
public const LegacyXlsDataConsolidationFunction Maximum #

Use the maximum source value.

Value: 3
public const LegacyXlsDataConsolidationFunction Minimum #

Use the minimum source value.

Value: 4
public const LegacyXlsDataConsolidationFunction Product #

Multiply source values.

Value: 5
public const LegacyXlsDataConsolidationFunction StandardDeviation #

Calculate sample standard deviation.

Value: 6
public const LegacyXlsDataConsolidationFunction StandardDeviationP #

Calculate population standard deviation.

Value: 7
public const LegacyXlsDataConsolidationFunction Sum #

Sum source values.

Value: 8
public const LegacyXlsDataConsolidationFunction Variance #

Calculate sample variance.

Value: 9
public const LegacyXlsDataConsolidationFunction VarianceP #

Calculate population variance.

Value: 10