PTFormatType complexType

Contains information describing some formatting applied to the PivotTable view.

Type Information

Namespace urn:schemas-microsoft-com:office:excel
Schema name XML Spreadsheet 2000

Elements and Attributes

Child Elements

Element Description
PTRule Contains information describing an area of the PivotTable view.
FormatType Contains an enumeration that describes the type of formatting.
IndividualCellBorders 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.

Attributes

Attribute Type Required Description Possible Values
Style xsd:string required Specifies the formatting to be applied. See external namespace.

Definition

      
<xsd:complexType name="PTFormatType" >
  <xsd:sequence>
    <xsd:element name="PTRule" type="PTRuleType" minOccurs="0" maxOccurs="unbounded">
    </xsd:element>
    <xsd:element name="FormatType" default="Format" minOccurs="0">
      <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:element>
  </xsd:sequence>
  <xsd:attribute name="Style" type="xsd:string" use="required">
  </xsd:attribute>
</xsd:complexType>


    
©2003-2004 Microsoft Corporation. All rights reserved. Permission to copy, display and distribute this document is available at: http://msdn.microsoft.com/library/en-us/odcXMLRef/html/odcXMLRefLegalNotice.asp