Documentation for Microsoft Office 2003 Reference Schemas
Definition Type: ComplexType
Name: PivotItemType
Namespace: urn:schemas-microsoft-com:office:excel
Containing Schema: excel.xsd
Abstract
Documentation:
Contains information on an item (PivotItem) in a PivotField.
Collapse XSD Schema Diagram:
Drilldown into DrilledMember in schema excel_xsd Drilldown into SourceName in schema excel_xsd Drilldown into Member in schema excel_xsd Drilldown into CachePosition in schema excel_xsd Drilldown into Missing in schema excel_xsd Drilldown into HideDetail in schema excel_xsd Drilldown into Hidden 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_xsd Drilldown into Name in schema excel_xsdXSD Diagram of PivotItemType in schema excel_xsd (Microsoft Office 2003 Reference Schemas)
Collapse XSD Schema Code: 
<xsd:complexType name="PivotItemType">
    <xsd:annotation>
        <xsd:documentation>Contains information on an item (PivotItem) in a PivotField.</xsd:documentation>
    </xsd:annotation>
    <xsd:sequence>
        <xsd:element name="Name" type="xsd:string">
            <xsd:annotation>
                <xsd:documentation>Contains the user-defined name of an object, range, or reference to another workbook, the location and name of a text file, or the built-in name of a range.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="Formula" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies a formula used to set the value of the PivotItem.</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 the order in which formulas are to be calculated for PivotItems that use multiple formulas.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="Hidden" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies that the item is to be hidden.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="HideDetail" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a Boolean indicating if detail data should not be shown for this PivotItem.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="Missing" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a Boolean indicating whether or not the PivotItem is currently used in the data source.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="CachePosition" type="xsd:int" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Indicates what data source item this PivotItem maps to in a PivotField that has been grouped.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="Member" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether the PivotItem element contains the name of a member instead of another string or value.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="SourceName" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the name of the item in the data source that data is to be drawn from. Required only when the value of the Name element is different from the name of the item in the data source.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="DrilledMember" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a boolean value that indicated that the user has drilled down on an OLAP based PivotTable.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
    </xsd:sequence>
</xsd:complexType>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
Name x:Name (1) (1)
Formula x:Formula 0 (1)
FormulaV10 x:FormulaV10 0 (1)
ParseFormulaAsV10 x:ParseFormulaAsV10 0 (1)
FormulaIndex x:FormulaIndex 0 (1)
Hidden x:Hidden 0 (1)
HideDetail x:HideDetail 0 (1)
Missing x:Missing 0 (1)
CachePosition x:CachePosition 0 (1)
Member x:Member 0 (1)
SourceName x:SourceName 0 (1)
DrilledMember x:DrilledMember 0 (1)
Collapse Derivation Tree:
Collapse References:
x:PivotItem, x:PivotItemx:PLTPivotItem,
Documentation for Microsoft Office 2003 Reference Schemas

Generated using Liquid Studio - Developer Bundle 21.0.0.0