PTRule element (PTFormulaType complexType)

Contains information describing an area of the PivotTable.

Usage

      
<PTRule />

    

Element Information

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

Elements and Attributes

Parent Elements

Element Description
PTFormula Contains information describing a PivotTable formula that doesn't apply to a whole PivotField or all PivotItems with the same name.

Child Elements

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.

Attributes

None.

Definition

      
<xsd:element name="PTRule" type="PTRuleType" minOccurs="0" >
</xsd:element>


    
©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