Documentation for Microsoft Office 2003 Reference Schemas
Definition Type: ComplexType
Name: PLPivotFieldType
Namespace: urn:schemas-microsoft-com:office:excel
Containing Schema: excel.xsd
Abstract
Documentation:
This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components.
Collapse XSD Schema Diagram:
Drilldown into PivotItem in schema excel_xsd Drilldown into TotalWidth in schema excel_xsd Drilldown into Expanded in schema excel_xsd Drilldown into GroupedWidth in schema excel_xsd Drilldown into DetailWidth in schema excel_xsd Drilldown into SubtotalFormat in schema excel_xsd Drilldown into DetailFormat in schema excel_xsd Drilldown into PLSubtotal in schema excel_xsd Drilldown into Subtotal in schema excel_xsd Drilldown into NewItemsHidden in schema excel_xsd Drilldown into Caption in schema excel_xsd Drilldown into CurrentPage in schema excel_xsd Drilldown into NumberFormat in schema excel_xsd Drilldown into ShowAllItems in schema excel_xsd Drilldown into Position in schema excel_xsd Drilldown into Orientation in schema excel_xsd Drilldown into PLPosition in schema excel_xsd Drilldown into PLDataOrientation in schema excel_xsd Drilldown into FilterCaption in schema excel_xsd Drilldown into DataType in schema excel_xsd Drilldown into BoundField in schema excel_xsd Drilldown into SourceName in schema excel_xsd Drilldown into Name in schema excel_xsdXSD Diagram of PLPivotFieldType in schema excel_xsd (Microsoft Office 2003 Reference Schemas)
Collapse XSD Schema Code: 
<xsd:complexType name="PLPivotFieldType">
    <xsd:annotation>
        <xsd:documentation>This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components.</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="SourceName" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains the name of a field or item as it appears in a PivotTable cache.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="BoundField" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether the PivotTable field is the bound field of an automatic date field set.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="DataType" type="DataTypeType" default="String" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies either the data type of a column in a PivotTable cache, or the data type of a PivotTable field for non-OLAP data sources.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="FilterCaption" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains the caption of a field set when the field set is the current filter.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="PLDataOrientation" type="xsd:int" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether a field is on the detail grid.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="PLPosition" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the position of a field in the detail grid.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="Orientation" type="OrientationType" default="Hidden" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether the field is to be used for row headers, column headers, page area, as data, or is hidden.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="Position" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the position of a PivotField when multiple fields are used.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="ShowAllItems" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a Boolean value indicating whether all PivotItems should be shown even if they have no data.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="NumberFormat" type="NumberFormatType" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the display formatting to use when displaying the PivotItem or aggregate value.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="CurrentPage" type="xsd:string" default="All" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the name of the PivotItem selected for a PivotField when the PivotField is in the page area.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="Caption" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains the displayed name of a PivotTable field, the title of a chart, or the caption of a data label, series, Spreadsheet component, or trendline. For a PivotList component, contains the axis label, displayed name of a total, or the current filter value or page name.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="NewItemsHidden" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a Boolean indicating whether new items from a refresh operation will be hidden by default in the PivotTable report or displayed.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="Subtotal" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains an enumeration indicating a type of subtotal to show for the PivotField. This element can appear multiple times specifying different subtotal types.</xsd:documentation>
            </xsd:annotation>
            <xsd:simpleType>
                <xsd:restriction base="xsd:string">
                    <xsd:enumeration value="Sum" />
                    <xsd:enumeration value="None" />
                    <xsd:enumeration value="Default" />
                </xsd:restriction>
            </xsd:simpleType>
        </xsd:element>
        <xsd:element name="PLSubtotal" type="xsd:double" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains the subtotal to display when a PivotTable field is not on the column or row axis.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="DetailFormat" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the text formatting that is applied to a field when it is on the detail grid.</xsd:documentation>
            </xsd:annotation>
            <xsd:complexType>
                <xsd:attribute name="Style" type="xsd:string" use="required">
                    <xsd:annotation>
                        <xsd:documentation>Specifies a text string containing attributes that describe the font weight, style, and effects that are applied to a field.</xsd:documentation>
                    </xsd:annotation>
                </xsd:attribute>
            </xsd:complexType>
        </xsd:element>
        <xsd:element name="SubtotalFormat" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the text formatting that is applied to a subtotal.</xsd:documentation>
            </xsd:annotation>
            <xsd:complexType>
                <xsd:attribute name="Style" type="xsd:string" use="required">
                    <xsd:annotation>
                        <xsd:documentation>Specifies a text string containing attributes that describe the font weight, style, and effects that are applied to a subtotal.</xsd:documentation>
                    </xsd:annotation>
                </xsd:attribute>
            </xsd:complexType>
        </xsd:element>
        <xsd:element name="DetailWidth" type="xsd:int" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the width of a field (in pixels) when it appears on the detail axis.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="GroupedWidth" type="xsd:int" default="50" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the width of a field (in pixels) when on the grouping axis, and whether the column width of a field is set automatically when the field is used on the row or column axis.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="Expanded" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether the field members are expanded by default, or whether a leaf member was expanded.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="TotalWidth" type="xsd:int" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the width of a total and whether the width is automatically set.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="PivotItem" type="PivotItemType" minOccurs="0" maxOccurs="unbounded">
            <xsd:annotation>
                <xsd:documentation>Contains information on an item (PivotItem) in the PivotField.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
    </xsd:sequence>
</xsd:complexType>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
Name x:Name (1) (1)
SourceName x:SourceName 0 (1)
BoundField x:BoundField 0 (1)
DataType x:DataType 0 (1)
FilterCaption x:FilterCaption 0 (1)
PLDataOrientation x:PLDataOrientation 0 (1)
PLPosition x:PLPosition 0 (1)
Orientation x:Orientation 0 (1)
Position x:Position 0 (1)
ShowAllItems x:ShowAllItems 0 (1)
NumberFormat x:NumberFormat 0 (1)
CurrentPage x:CurrentPage 0 (1)
Caption x:Caption 0 (1)
NewItemsHidden x:NewItemsHidden 0 (1)
Subtotal x:Subtotal 0 (1)
PLSubtotal x:PLSubtotal 0 (1)
DetailFormat x:DetailFormat 0 (1)
SubtotalFormat x:SubtotalFormat 0 (1)
DetailWidth x:DetailWidth 0 (1)
GroupedWidth x:GroupedWidth 0 (1)
Expanded x:Expanded 0 (1)
TotalWidth x:TotalWidth 0 (1)
PivotItem x:PivotItem 0 unbounded
Collapse Derivation Tree:
Collapse References:
x:PLPivotField
Documentation for Microsoft Office 2003 Reference Schemas

Generated using Liquid Studio - Developer Bundle 21.0.0.0