PivotFormula Interface

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Represents a formula used to calculate results in a PivotTable report.

public interface class PivotFormula

[System.Runtime.InteropServices.Guid("0002441E-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface PivotFormula

Public Interface PivotFormula

Attributes: GuidAttribute InterfaceTypeAttribute

Remarks

Use PivotFormulas(index), where index is the formula number or string on the left side of the formula, to return the PivotFormula object.

This object and its associated properties and methods aren’t available for OLAP data sources because calculated fields and items aren’t supported.

Properties

_Default	Reserved for internal use.
Application	Returns an Application object that represents the Microsoft Excel application.
Creator	Returns a 32-bit integer that indicates the application in which this object was created.
Formula	Returns or sets the object's formula in A1-style notation.
Index	Returns or sets the index number of the object within the PivotFormulas collection.
Parent	Returns the parent object for the specified object.
StandardFormula	Returns or sets a String specifying formulas with standard English (United States) formatting.
Value	The name of the specified formula in the PivotTable formula.

Methods

Delete()

Deletes the object.

Applies to