PivotFormula Interface
Definition
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
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. |