Documentation for Microsoft Office 2003 Reference Schemas
Definition Type: ComplexType
Name: PTFormulaType
Namespace: urn:schemas-microsoft-com:office:excel
Containing Schema: excel.xsd
Abstract
Documentation:
Contains information describing a PivotTable formula that doesn't apply to a whole PivotField or all PivotItems with the same name.
Collapse XSD Schema Diagram:
Drilldown into PTRule in schema excel_xsd Drilldown into FormulaIndex in schema excel_xsd Drilldown into ParseFormulaAsV10 in schema excel_xsd Drilldown into FormulaV10 in schema excel_xsd Drilldown into Formula in schema excel_xsdXSD Diagram of PTFormulaType in schema excel_xsd (Microsoft Office 2003 Reference Schemas)
Collapse XSD Schema Code: 
<xsd:complexType name="PTFormulaType">
    <xsd:annotation>
        <xsd:documentation>Contains information describing a PivotTable formula that doesn't apply to a whole PivotField or all PivotItems with the same name.</xsd:documentation>
    </xsd:annotation>
    <xsd:sequence>
        <xsd:element name="Formula" type="xsd:string">
            <xsd:annotation>
                <xsd:documentation>Specifies the formula that doesn't apply to a whole PivotField or all PivotItems with the same name.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="FormulaV10" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>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.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="ParseFormulaAsV10" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies that the string in the Formula element is to be processed as if it is an English string (a V10 formula).</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="FormulaIndex" type="xsd:int" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies a number that controls the order in which formulas are applied.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="PTRule" type="PTRuleType" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains information describing an area of the PivotTable.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
    </xsd:sequence>
</xsd:complexType>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
Formula x:Formula (1) (1)
FormulaV10 x:FormulaV10 0 (1)
ParseFormulaAsV10 x:ParseFormulaAsV10 0 (1)
FormulaIndex x:FormulaIndex 0 (1)
PTRule x:PTRule 0 (1)
Collapse Derivation Tree:
Collapse References:
x:PTFormula
Documentation for Microsoft Office 2003 Reference Schemas

Generated using Liquid Studio - Developer Bundle 21.0.0.0