ExcelPivotCalculatedFieldInfo

Edit on GitHub

Namespace OfficeIMO.Excel

Assembly OfficeIMO.Excel

Source ExcelPivotCalculatedFieldInfo.cs:9

Modifiers sealed

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

Inheritance

Object
ExcelPivotCalculatedFieldInfo

Usage

Explore 2 API references to this type

This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.

Returned or exposed by 1

Property ExcelPivotTableInfo.CalculatedFields

Accepted by parameters 1

Constructor ExcelPivotTableInfo.ExcelPivotTableInfo parameter calculatedFields

Constructors

public ExcelPivotCalculatedFieldInfo(String name, String formula, String? caption = null, UInt32? numberFormatId = null, String? numberFormatCode = null)

ExcelPivotCalculatedFieldInfo.cs:9

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.UInt32? = null optionalposition: 3
numberFormatCode System.String? = null optionalposition: 4

Inherited Methods

Properties

public String Name { get; } #

ExcelPivotCalculatedFieldInfo.cs:18

Gets the calculated field name.

public String Formula { get; } #

ExcelPivotCalculatedFieldInfo.cs:21

Gets the calculated field formula.

public String? Caption { get; } #

ExcelPivotCalculatedFieldInfo.cs:24

Gets the optional display caption.

public UInt32? NumberFormatId { get; } #

ExcelPivotCalculatedFieldInfo.cs:27

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

public String? NumberFormatCode { get; } #

ExcelPivotCalculatedFieldInfo.cs:30

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