Get Started

API Reference

Enum

LegacyXlsPivotItemType

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 item type stored in an SXVI PivotTable item record.

Inheritance

  • Enum
  • LegacyXlsPivotItemType

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 LegacyXlsPivotItemType Data #

Regular data item.

Value: 0
public const LegacyXlsPivotItemType Default #

Default subtotal item.

Value: 1
public const LegacyXlsPivotItemType Sum #

Sum subtotal item.

Value: 2
public const LegacyXlsPivotItemType CountValues #

Count values subtotal item.

Value: 3
public const LegacyXlsPivotItemType Average #

Average subtotal item.

Value: 4
public const LegacyXlsPivotItemType Max #

Maximum subtotal item.

Value: 5
public const LegacyXlsPivotItemType Min #

Minimum subtotal item.

Value: 6
public const LegacyXlsPivotItemType Product #

Product subtotal item.

Value: 7
public const LegacyXlsPivotItemType CountNumbers #

Count numbers subtotal item.

Value: 8
public const LegacyXlsPivotItemType StandardDeviation #

Standard deviation subtotal item.

Value: 9
public const LegacyXlsPivotItemType StandardDeviationPopulation #

Population standard deviation subtotal item.

Value: 10
public const LegacyXlsPivotItemType Variance #

Variance subtotal item.

Value: 11
public const LegacyXlsPivotItemType VariancePopulation #

Population variance subtotal item.

Value: 12