complexType PTLineItemType

complexType {urn:schemas-microsoft-com:office:excel}PTLineItemType

Abstractfalse (This can be used in an instance)
Target Namespaceurn:schemas-microsoft-com:office:excel
Declared Namespacesxmlns:xsd=http://www.w3.org/2001/XMLSchema
xmlns:rs=urn:schemas-microsoft-com:rowset
xmlns:s=uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882
xmlns=urn:schemas-microsoft-com:office:excel


Source

<xsd:complexType name="PTLineItemType">
    <
xsd:annotation>
        <
xsd:documentation>Describes the layout of one row or column line in the PivotTable view.</xsd:documentation>
    </
xsd:annotation>
    <
xsd:sequence>
        <
xsd:element name="ItemType" default="Data" minOccurs="0">
            <
xsd:annotation>
                <
xsd:documentation>Specifies the type of data that is to appear in this row or column in the PivotTable view.</xsd:documentation>
            </
xsd:annotation>
            <
xsd:simpleType>
                <
xsd:restriction base="xsd:string">
                    <
xsd:enumeration value="Avg"/>
                    <
xsd:enumeration value="Count"/>
                    <
xsd:enumeration value="CountNums"/>
                    <
xsd:enumeration value="Max"/>
                    <
xsd:enumeration value="Min"/>
                    <
xsd:enumeration value="Product"/>
                    <
xsd:enumeration value="StdDev"/>
                    <
xsd:enumeration value="StdDevP"/>
                    <
xsd:enumeration value="Sum"/>
                    <
xsd:enumeration value="Var"/>
                    <
xsd:enumeration value="VarP"/>
                    <
xsd:enumeration value="Blank"/>
                    <
xsd:enumeration value="Data"/>
                    <
xsd:enumeration value="Default"/>
                    <
xsd:enumeration value="Grand"/>
                </
xsd:restriction>
            </
xsd:simpleType>
        </
xsd:element>
        <
xsd:element name="DataField" type="xsd:integer" default="1" minOccurs="0">
            <
xsd:annotation>
                <
xsd:documentation>Specifies which data field (of the PivotField items) this PTLineItem represents.</xsd:documentation>
            </
xsd:annotation>
        </
xsd:element>
        <
xsd:element name="BlockTotal" minOccurs="0">
            <
xsd:annotation>
                <
xsd:documentation>Contains a Boolean indicating if this PTLineItem is for a block total (a special type of subtotal displayed at the bottom of the PivotTable view).</xsd:documentation>
            </
xsd:annotation>
        </
xsd:element>
        <
xsd:element name="CountOfSameItems" type="xsd:int" default="0" minOccurs="0">
            <
xsd:annotation>
                <
xsd:documentation>Indicates how many repetitions of the outside header are required where columns or rows have multiple headers.</xsd:documentation>
            </
xsd:annotation>
        </
xsd:element>
        <
xsd:element name="Item" type="xsd:string" minOccurs="0" maxOccurs="unbounded">
            <
xsd:annotation>
                <
xsd:documentation>Contains the index for PivotItems.</xsd:documentation>
            </
xsd:annotation>
        </
xsd:element>
    </
xsd:sequence>
</
xsd:complexType>


Documentation

Describes the layout of one row or column line in the PivotTable view.


complexType PTLineItemType


Stylus Studio XML Schema Library Home
Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio®, a product from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2006 All Rights Reserved.