Definition Type: ComplexType
Name: PTFormatType
Namespace: urn:schemas-microsoft-com:office:excel
Containing Schema: excel.xsd
Abstract
Documentation:
Contains information describing some formatting applied to the PivotTable view.
Collapse XSD Schema Diagram:
Drilldown into IndividualCellBorders in schema excel_xsd Drilldown into FormatType in schema excel_xsd Drilldown into PTRule in schema excel_xsd Drilldown into Style in schema excel_xsdXSD Diagram of PTFormatType in schema excel_xsd (Microsoft Office 2003 Reference Schemas)
Collapse XSD Schema Code:
<xsd:complexType name="PTFormatType">
    <xsd:annotation>
        <xsd:documentation>Contains information describing some formatting applied to the PivotTable view.</xsd:documentation>
    </xsd:annotation>
    <xsd:sequence>
        <xsd:element name="PTRule" type="PTRuleType" minOccurs="0" maxOccurs="unbounded">
            <xsd:annotation>
                <xsd:documentation>Contains information describing an area of the PivotTable view.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="FormatType" default="Format" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains an enumeration that describes the type of formatting.</xsd:documentation>
            </xsd:annotation>
            <xsd:simpleType>
                <xsd:restriction base="xsd:string">
                    <xsd:enumeration value="Format" />
                    <xsd:enumeration value="Blank" />
                </xsd:restriction>
            </xsd:simpleType>
        </xsd:element>
        <xsd:element name="IndividualCellBorders" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a Boolean indicating whether border formatting applies only to the cell being formatted or to that cell and to cells that share the border with it.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="Style" type="xsd:string" use="required">
        <xsd:annotation>
            <xsd:documentation>Specifies the formatting to be applied.</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
</xsd:complexType>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
PTRule x:PTRule 0 unbounded
FormatType x:FormatType 0 (1)
IndividualCellBorders x:IndividualCellBorders 0 (1)
Collapse Child Attributes:
Name Type Default Value Use
Style x:Style Required
Collapse Derivation Tree:
Collapse References:
x:PTFormat