[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
fieldGroup (Field Group Properties)
Represents the collection of properties for a field group.
[Example:
…
<fieldGroup par="6" base="0">
<rangePr groupBy="months" startDate="2002-01-01T00:00:00"
endDate="2006-05-06T00:00:00"/>
<groupItems count="14">
<s v="<1/1/2002"/>
<s v="Jan"/>
<s v="Feb"/>
<s v="Mar"/>
<s v="Apr"/>
<s v="May"/>
<s v="Jun"/>
<s v="Jul"/>
<s v="Aug"/>
<s v="Sep"/>
<s v="Oct"/>
<s v="Nov"/>
<s v="Dec"/>
<s v=">5/6/2006"/>
</groupItems>
</fieldGroup>
</cacheField>
<cacheField name="Name" numFmtId="0">
<sharedItems count="4">
<s v="Joe"/>
<s v="John"/>
<s v="Bob"/>
<s v="Robert"/>
</sharedItems>
<fieldGroup par="4"/>
</cacheField>
<cacheField name="ProductID" numFmtId="0">
<sharedItems containsSemiMixedTypes="0" containsString="0" containsNumber="1"
containsInteger="1" minValue="1" maxValue="4" count="4">
<n v="1"/>
<n v="2"/>
<n v="3"/>
<n v="4"/>
</sharedItems>
<fieldGroup base="2">
<rangePr startNum="1" endNum="4" groupInterval="2"/>
<groupItems count="4">
<s v="<1"/>
<s v="1-2"/>
<s v="3-4"/>
<s v=">5"/>
</groupItems>
</fieldGroup>
…
end example]
Parent Elements |
cacheField (§3.10.1.3) |
Child Elements |
Subclause |
discretePr (Discrete Grouping Properties) |
§3.10.1.26 |
groupItems (OLAP Group Items) |
§3.10.1.38 |
rangePr (Range Grouping Properties) |
§3.10.1.78 |
Attributes |
Description |
base (Field Base) |
Specifies the base of this field, if any.
The possible values for this attribute are defined by the XML Schema unsignedInt datatype. |
par (Parent) |
Specifies the parent of this field, if any.
The possible values for this attribute are defined by the XML Schema unsignedInt datatype. |
The following XML Schema fragment defines the contents of this element:
<complexType name="CT_FieldGroup">
<sequence>
<element name="rangePr" minOccurs="0" type="CT_RangePr"/>
<element name="discretePr" minOccurs="0" type="CT_DiscretePr"/>
<element name="groupItems" minOccurs="0" type="CT_GroupItems"/>
</sequence>
<attribute name="par" type="xsd:unsignedInt" use="optional"/>
<attribute name="base" type="xsd:unsignedInt" use="optional"/>
</complexType>