ssml:pivotSelection

PivotTable Selection

Element information

Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main

Schema document: sml-sheet.xsd

Type: ssml:CT_PivotSelection

Properties: Local, Qualified

Content

ssml:pivotArea [1..1] Pivot Area

Attributes

Name	Occ	Type	Description	Notes
pane	[0..1]	ssml:ST_Pane	Pane	Default value is "topLeft".
showHeader	[0..1]	xsd:boolean	Show Header	Default value is "false".
label	[0..1]	xsd:boolean	Label	Default value is "false".
data	[0..1]	xsd:boolean	Data Selection	Default value is "false".
extendable	[0..1]	xsd:boolean	Extendable	Default value is "false".
count	[0..1]	xsd:unsignedInt	Selection Count	Default value is "0".
axis	[0..1]	ssml:ST_Axis	Axis
dimension	[0..1]	xsd:unsignedInt	Dimension	Default value is "0".
start	[0..1]	xsd:unsignedInt	Start	Default value is "0".
min	[0..1]	xsd:unsignedInt	Minimum	Default value is "0".
max	[0..1]	xsd:unsignedInt	Maximum	Default value is "0".
activeRow	[0..1]	xsd:unsignedInt	Active Row	Default value is "0".
activeCol	[0..1]	xsd:unsignedInt	Active Column	Default value is "0".
previousRow	[0..1]	xsd:unsignedInt	Previous Row	Default value is "0".
previousCol	[0..1]	xsd:unsignedInt	Previous Column Selection	Default value is "0".
click	[0..1]	xsd:unsignedInt	Click Count	Default value is "0".
r:id	[0..1]	r:ST_RelationshipId	Relationship Id

Used in

Type ssml:CT_SheetView (Element ssml:sheetView)

Sample instance

<ssml:pivotSelection>
   <ssml:pivotArea>
      <ssml:references>
         <ssml:reference>...
         </ssml:reference>
      </ssml:references>
      <ssml:extLst>
         <ssml:ext>
            <!--any element-->
         </ssml:ext>
      </ssml:extLst>
   </ssml:pivotArea>
</ssml:pivotSelection>