ssml:pivotArea
Pivot Area
Element information
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Schema document: sml-pivotTable.xsd
Other elements with the same name: ssml:pivotArea, ssml:pivotArea, ssml:pivotArea, ssml:pivotArea
Type: ssml:CT_PivotArea
Properties: Local, Qualified
Content
- Sequence [1..1]
- ssml:references [0..1] References
- ssml:extLst [0..1] Future Feature Storage Area
Attributes
| Name | Occ | Type | Description | Notes |
|---|---|---|---|---|
| field | [0..1] | xsd:int | Field Index | |
| type | [0..1] | ssml:ST_PivotAreaType | Rule Type | Default value is "normal". |
| dataOnly | [0..1] | xsd:boolean | Data Only | Default value is "true". |
| labelOnly | [0..1] | xsd:boolean | Labels Only | Default value is "false". |
| grandRow | [0..1] | xsd:boolean | Include Row Grand Total | Default value is "false". |
| grandCol | [0..1] | xsd:boolean | Include Column Grand Total | Default value is "false". |
| cacheIndex | [0..1] | xsd:boolean | Cache Index | Default value is "false". |
| outline | [0..1] | xsd:boolean | Outline | Default value is "true". |
| offset | [0..1] | ssml:ST_Ref | Offset Reference | |
| collapsedLevelsAreSubtotals | [0..1] | xsd:boolean | Collapsed Levels Are Subtotals | Default value is "false". |
| axis | [0..1] | ssml:ST_Axis | Axis | |
| fieldPosition | [0..1] | xsd:unsignedInt | Field Position |
Used in
- Type ssml:CT_PivotAreas (Element ssml:pivotAreas)
- Type ssml:CT_PivotSelection (Element ssml:pivotSelection)
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>