API Reference
Class
ExcelPivotCalculatedField
Describes a formula-backed pivot cache field to author.
Inheritance
- Object
- ExcelPivotCalculatedField
Usage
This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.
Accepted by parameters
- Method ExcelSheet.AddPivotTable
Constructors
public ExcelPivotCalculatedField(String name, String formula, String caption = null, Nullable<UInt32> numberFormatId = null, String numberFormat = null) #Creates a calculated pivot field.
Parameters
- name System.String
- formula System.String
- caption System.String = null
- numberFormatId System.Nullable{System.UInt32} = null
- numberFormat System.String = null
Inherited Methods
public override Boolean Equals(Object obj) #Returns:
BooleanInherited from Object
Parameters
- obj Object
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 NumberFormat { get; } #Gets the optional number format code to add to the workbook styles.