Schema Central > OOXML > sml-pivotTable.xsd > ssml:pivotArea
Advanced search
Need XML Help?

Recommended Reading:

Definitive XML Schema

 

Web Service Contract Design and Versioning for SOA

 

Advanced XML Applications

 

ssml:pivotArea

Pivot Table Location Rule

Element information

Type: ssml:CT_PivotArea

Properties: Local, Qualified

Content

Attributes

NameOccTypeDescriptionNotes
field [0..1]xsd:intField Index
type [0..1]ssml:ST_PivotAreaTypeRule TypeDefault value is "normal".
dataOnly [0..1]xsd:booleanData OnlyDefault value is "true".
labelOnly [0..1]xsd:booleanLabels OnlyDefault value is "false".
grandRow [0..1]xsd:booleanInclude Row Grand TotalDefault value is "false".
grandCol [0..1]xsd:booleanInclude Column Grand TotalDefault value is "false".
cacheIndex [0..1]xsd:booleanCache IndexDefault value is "false".
outline [0..1]xsd:booleanOutlineDefault value is "true".
offset [0..1]ssml:ST_RefOffset Reference
collapsedLevelsAreSubtotals [0..1]xsd:booleanCollapsed Levels Are SubtotalsDefault value is "false".
axis [0..1]ssml:ST_AxisAxis
fieldPosition [0..1]xsd:unsignedIntField Position

Used in

Sample instance

<ssml:pivotArea>
   <ssml:references>
      <ssml:reference>
         <ssml:x v="1"/>
         <ssml:extLst>...
         </ssml:extLst>
      </ssml:reference>
   </ssml:references>
   <ssml:extLst>
      <ssml:ext>
         <!--any element-->
      </ssml:ext>
   </ssml:extLst>
</ssml:pivotArea>

Site developed and hosted by Datypic, Inc.

Please report errors or comments about this site to contrib@functx.com