Share via

2.7.30 ST_ModelTimeGroupingContentType

  • Article

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2014/11/main

Referenced by: CT_CalculatedTimeColumn

Specifies the grouping content type inside a calculated column.

Value

Meaning

years

Years

quarters

Quarters

monthsindex

Months Index

months

Months

daysindex

Days Index

days

Days

hours

Hours

minutes

Minutes

seconds

Seconds

The following W3C XML Schema ([XMLSCHEMA1/2] section 2.1) fragment specifies the contents of this simple type.

 <xsd:simpleType name="ST_ModelTimeGroupingContentType">
   <xsd:restriction base="x:ST_Xstring">
     <xsd:enumeration value="years"/>
     <xsd:enumeration value="quarters"/>
     <xsd:enumeration value="monthsindex"/>
     <xsd:enumeration value="months"/>
     <xsd:enumeration value="daysindex"/>
     <xsd:enumeration value="days"/>
     <xsd:enumeration value="hours"/>
     <xsd:enumeration value="minutes"/>
     <xsd:enumeration value="seconds"/>
   </xsd:restriction>
 </xsd:simpleType>

See section 5.10 for the full W3C XML Schema ([XMLSCHEMA1/2] section 2.1).