Get Started

API Reference

Enum

LegacyXlsPivotLineItemType

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 SXLI PivotTable line item.

Inheritance

  • Enum
  • LegacyXlsPivotLineItemType

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

Regular data item.

Value: 0
public const LegacyXlsPivotLineItemType Default #

Default subtotal item.

Value: 1
public const LegacyXlsPivotLineItemType Sum #

Sum subtotal item.

Value: 2
public const LegacyXlsPivotLineItemType CountValues #

Count values subtotal item.

Value: 3
public const LegacyXlsPivotLineItemType CountNumbers #

Count numbers subtotal item.

Value: 4
public const LegacyXlsPivotLineItemType Average #

Average subtotal item.

Value: 5
public const LegacyXlsPivotLineItemType Max #

Maximum subtotal item.

Value: 6
public const LegacyXlsPivotLineItemType Min #

Minimum subtotal item.

Value: 7
public const LegacyXlsPivotLineItemType Product #

Product subtotal item.

Value: 8
public const LegacyXlsPivotLineItemType StandardDeviation #

Standard deviation subtotal item.

Value: 9
public const LegacyXlsPivotLineItemType StandardDeviationPopulation #

Population standard deviation subtotal item.

Value: 10
public const LegacyXlsPivotLineItemType Variance #

Variance subtotal item.

Value: 11
public const LegacyXlsPivotLineItemType VariancePopulation #

Population variance subtotal item.

Value: 12
public const LegacyXlsPivotLineItemType GrandTotal #

Grand total item.

Value: 13
public const LegacyXlsPivotLineItemType BlankLine #

Blank pivot line.

Value: 14