Contains information describing an area of the PivotTable.
Namespace | urn:schemas-microsoft-com:office:excel |
Schema name | XML Spreadsheet 2000 |
Element | Description |
---|---|
RuleType | Contains an enumeration that describes the type of PivotTable area to which the PTRule refers. |
Rule | Contains a text string describing the area to which the PTRule refers. |
RuleV10 | Contains a text string describing the area to which the PTRule refers. |
ParseRuleAsV10 | Specifies that a rule is to be processed as if it is an English string (V10). |
Area | Describes a sub-section of a PivotTable area. |
Outline | Contains a Boolean value indicating that a rule describes a PivotTable area that includes one or more fields set to display in outline mode. |
None.
<xsd:complexType name="PTRuleType" >
<xsd:sequence>
<xsd:element name="RuleType" default="DataLabel" minOccurs="0">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="Blanks" />
<xsd:enumeration value="Button" />
<xsd:enumeration value="DataLabel" />
<xsd:enumeration value="DataOnly" />
<xsd:enumeration value="LabelOnly" />
<xsd:enumeration value="Origin" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="Rule" type="xsd:string" minOccurs="0">
</xsd:element>
<xsd:element name="RuleV10" type="xsd:string" minOccurs="0">
</xsd:element>
<xsd:element name="ParseRuleAsV10" minOccurs="0">
</xsd:element>
<xsd:element name="Area" type="xsd:string" minOccurs="0">
</xsd:element>
<xsd:element name="Outline" minOccurs="0">
</xsd:element>
</xsd:sequence>
</xsd:complexType>