ssml:reference

Reference

Element information

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

Schema document: sml-pivotTableShared.xsd

Type: ssml:CT_PivotAreaReference

Properties: Local, Qualified

Content

Sequence [1..1]
1. ssml:x [0..*] Field Item
2. ssml:extLst [0..1] Future Feature Storage Area

Attributes

Name	Occ	Type	Description	Notes
field	[0..1]	xsd:unsignedInt	Field Index
count	[0..1]	xsd:unsignedInt	Item Index Count
selected	[0..1]	xsd:boolean	Selected	Default value is "true".
byPosition	[0..1]	xsd:boolean	Positional Reference	Default value is "false".
relative	[0..1]	xsd:boolean	Relative Reference	Default value is "false".
defaultSubtotal	[0..1]	xsd:boolean	Include Default Filter	Default value is "false".
sumSubtotal	[0..1]	xsd:boolean	Include Sum Filter	Default value is "false".
countASubtotal	[0..1]	xsd:boolean	Include CountA Filter	Default value is "false".
avgSubtotal	[0..1]	xsd:boolean	Include Average Filter	Default value is "false".
maxSubtotal	[0..1]	xsd:boolean	Include Maximum Filter	Default value is "false".
minSubtotal	[0..1]	xsd:boolean	Include Minimum Filter	Default value is "false".
productSubtotal	[0..1]	xsd:boolean	Include Product Filter	Default value is "false".
countSubtotal	[0..1]	xsd:boolean	Include Count Subtotal	Default value is "false".
stdDevSubtotal	[0..1]	xsd:boolean	Include StdDev Filter	Default value is "false".
stdDevPSubtotal	[0..1]	xsd:boolean	Include StdDevP Filter	Default value is "false".
varSubtotal	[0..1]	xsd:boolean	Include Var Filter	Default value is "false".
varPSubtotal	[0..1]	xsd:boolean	Include VarP Filter	Default value is "false".

Used in

Type ssml:CT_PivotAreaReferences (Element ssml:references)

Sample instance

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