[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

ST_DateTimeGrouping (Date Time Grouping)

Specifies how to group dateTime values.

This simple type's contents are a restriction of the XML Schema string datatype.

The following are possible enumeration values for this type:

Enumeration Value

Description

day (Day)

Group by day

hour (Group by Hour)

Group by hour

minute (Group by Minute)

Group by minute

month (Month)

Group by month

second (Second)

Group by second

year (Group by Year)

Group by year

 

Referenced By

dateGroupItem@dateTimeGrouping3.3.2.4)

The following XML Schema fragment defines the contents of this simple type:

<simpleType name="ST_DateTimeGrouping">

   <restriction base="xsd:string">

   <enumeration value="year"/>

   <enumeration value="month"/>

   <enumeration value="day"/>

   <enumeration value="hour"/>

   <enumeration value="minute"/>

   <enumeration value="second"/>

   </restriction>

</simpleType>