PTFormula element

Contains information describing a PivotTable formula that doesn't apply to a whole PivotField or all PivotItems with the same name.

Usage

      
<PTFormula />

Element Information

Element type PTFormulaType
Namespace urn:schemas-microsoft-com:office:excel
Schema name XML Spreadsheet 2000

Elements and Attributes

Parent Elements

Element Description
PivotTable Contains information about a PivotTable view.

Child Elements

Element Description
Formula Specifies the formula that doesn't apply to a whole PivotField or all PivotItems with the same name.
FormulaV10 Contains the string of the Formula element with English locale. This string is generated only generated when the English version of the Formula string is different from the string in the Formula element.
ParseFormulaAsV10 Specifies that the string in the Formula element is to be processed as if it is an English string (a V10 formula).
FormulaIndex Specifies a number that controls the order in which formulas are applied.
PTRule Contains information describing an area of the PivotTable.

Attributes

None.

Definition

      
<xsd:element name="PTFormula" type="PTFormulaType" minOccurs="0" maxOccurs="unbounded" >
</xsd:element>
©2003-2004 Microsoft Corporation. All rights reserved. Permission to copy, display and distribute this document is available at: http://msdn.microsoft.com/library/en-us/odcXMLRef/html/odcXMLRefLegalNotice.asp