API Reference

Class

ExcelPivotCalculatedFieldInfo

Namespace OfficeIMO.Excel
Assembly OfficeIMO.Excel
Modifiers sealed

Describes a calculated pivot cache field found in an existing pivot table.

Inheritance

  • Object
  • ExcelPivotCalculatedFieldInfo

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

Constructors

public ExcelPivotCalculatedFieldInfo(String name, String formula, String caption = null, Nullable<UInt32> numberFormatId = null, String numberFormatCode = null) #

Creates calculated pivot field readback information.

Parameters

name System.String requiredposition: 0
formula System.String requiredposition: 1
caption System.String = null optionalposition: 2
numberFormatId System.Nullable{System.UInt32} = null optionalposition: 3
numberFormatCode System.String = null optionalposition: 4

Properties

public String Name { get; } #

Gets the calculated field name.

public String Formula { get; } #

Gets the calculated field formula.

public String Caption { get; } #

Gets the optional display caption.

public Nullable<UInt32> NumberFormatId { get; } #

Gets the optional built-in/custom number format id.

public String NumberFormatCode { get; } #

Gets the custom number format code, when it can be resolved from workbook styles.