Skip to main content

Search OfficeIMO

Enter a topic, API type, or PowerShell command.

Documentation Search all OfficeIMO/

API Reference

Class

ExcelPivotCalculatedField

Namespace OfficeIMO.Excel
Assembly OfficeIMO.Excel
Modifiers sealed

Describes a formula-backed pivot cache field to author.

Inheritance

  • Object
  • ExcelPivotCalculatedField

Usage

Explore 1 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.

Accepted by parameters 1

Constructors

public ExcelPivotCalculatedField(String name, String formula, String? caption = null, UInt32? numberFormatId = null, String? numberFormat = null) #

Creates a calculated pivot field.

Parameters

name System.String requiredposition: 0
formula System.String requiredposition: 1
caption System.String? = null optionalposition: 2
numberFormatId System.UInt32? = null optionalposition: 3
numberFormat 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 UInt32? NumberFormatId { get; } #

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

public String? NumberFormat { get; } #

Gets the optional number format code to add to the workbook styles.