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. |
Applies to
意見反應
https://aka.ms/ContentUserFeedback。
即將登場:在 2024 年,我們將逐步淘汰 GitHub 問題作為內容的意見反應機制,並將它取代為新的意見反應系統。 如需詳細資訊,請參閱:提交並檢視相關的意見反應