[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

rangePr (Range Grouping Properties)

Represents the collection of range grouping properties.

[Example:

<rangePr groupBy="months" startDate="2002-01-01T00:00:00"
endDate="2006-05-06T00:00:00"/>

end example]

Parent Elements

fieldGroup3.10.1.30)

 

Attributes

Description

autoEnd (Source Data Ending Range)

Specifies a boolean value that indicates whether the application will use the source data to set the ending range value.

 

A value of on, 1, or true indicates the ending range value will be set from the source data.

 

A value of off, 0, or false indicates ending range values will be set by the value specified in endDate or endNum.

 

The possible values for this attribute are defined by the XML Schema boolean datatype.

autoStart (Source Data Set Beginning Range)

Specifies a boolean value that indicates whether we use source data to set the beginning range value.

 

A value of on, 1, or true indicates the beginning range value will be set from the source data.

 

A value of off, 0, or false indicates the beginning range value will be set from the value specified in startDate or startNum.

 

The possible values for this attribute are defined by the XML Schema boolean datatype.

endDate (Date Grouping End Value)

Specifies the ending value for date grouping if autoEnd is false.

 

The possible values for this attribute are defined by the XML Schema dateTime datatype.

endNum (Numeric Grouping End Value)

Specifies the ending value for numeric grouping if autoEnd is false.

 

The possible values for this attribute are defined by the XML Schema double datatype.

groupBy (Group By)

Specifies the grouping.

 

The possible values for this attribute are defined by the ST_GroupBy simple type (§3.18.39).

groupInterval (Grouping Interval)

Specifies the grouping interval for numeric range grouping. Specifies the number of days to group by in date range grouping.

 

The possible values for this attribute are defined by the XML Schema double datatype.

startDate (Date Grouping Start Value)

Specifies the starting value for date grouping if autoStart is false.

 

The possible values for this attribute are defined by the XML Schema dateTime datatype.

startNum (Numeric Grouping Start Value)

Specifies the starting value for numeric grouping if autoStart is false.

 

The possible values for this attribute are defined by the XML Schema double datatype.

The following XML Schema fragment defines the contents of this element:

<complexType name="CT_RangePr">

   <attribute name="autoStart" type="xsd:boolean" default="true"/>

   <attribute name="autoEnd" type="xsd:boolean" default="true"/>

   <attribute name="groupBy" type="ST_GroupBy" default="range"/>

   <attribute name="startNum" type="xsd:double"/>

   <attribute name="endNum" type="xsd:double"/>

   <attribute name="startDate" type="xsd:dateTime"/>

   <attribute name="endDate" type="xsd:dateTime"/>

   <attribute name="groupInterval" type="xsd:double" default="1"/>

</complexType>