Get Started

API Reference

Enum

LegacyXlsPivotDisplayCalculation

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 display calculation stored in an SXDI PivotTable data item record.

Inheritance

  • Enum
  • LegacyXlsPivotDisplayCalculation

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 LegacyXlsPivotDisplayCalculation Value #

Display the data item value directly.

Value: 0
public const LegacyXlsPivotDisplayCalculation DifferenceFrom #

Display the difference from a referenced pivot item.

Value: 1
public const LegacyXlsPivotDisplayCalculation PercentOf #

Display as a percentage of a referenced pivot item.

Value: 2
public const LegacyXlsPivotDisplayCalculation PercentDifferenceFrom #

Display as a percentage difference from a referenced pivot item.

Value: 3
public const LegacyXlsPivotDisplayCalculation RunningTotal #

Display as a running total for successive pivot items.

Value: 4
public const LegacyXlsPivotDisplayCalculation PercentOfRow #

Display as a percentage of the containing row total.

Value: 5
public const LegacyXlsPivotDisplayCalculation PercentOfColumn #

Display as a percentage of the containing column total.

Value: 6
public const LegacyXlsPivotDisplayCalculation PercentOfGrandTotal #

Display as a percentage of the grand total.

Value: 7
public const LegacyXlsPivotDisplayCalculation Index #

Display as index using row, column, and grand totals.

Value: 8