[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

header (Header)

This element is essentially a table that contains metadata about a list of specific changes that have taken place for this workbook. It lists when the changes were made, who made them, and the relationship IDs so that the log detailing the specific change can be found. If tracking changes, or sharing workbooks, are enabled, then changes are persisted on the Save event, or at a specified time interval. A header is created for each set of changes.

Parent Elements

Root element of SpreadsheetML Shared Workbook Revision Headers partheaders3.11.1.2)

 

Child Elements

Subclause

extLst (Future Feature Data Storage Area)

§3.2.10

reviewedList (Reviewed List)

§3.11.1.15

sheetIdMap (Sheet Id Map)

§3.11.1.24

 

Attributes

Description

dateTime (Date Time)

The date and time when this set of revisions was saved.

 

Note: This can happen when the user explicitly saves, or the save can occur due to a time interval, specified in the spreadsheet application, elapsing.

 

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

guid (GUID)

A globally unique identifier for this set of revisions.

 

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

id (Relationship ID)

 

Namespace: .../officeDocument/2006/relationships

This is the ID that is used to find the corresponding log record of the changes made for this header.

 

Use the corresponding relationship expressed in the revisionHeaders part to locate the log record that lists the specific changes.

 

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

maxRId (Max Revision Id)

The highest revision Id that belongs to this header.

 

Note: this can be used when, given a revision ID, the spreadsheet application needs to determine which revision log to access.

 

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

maxSheetId (Last Sheet Id)

Internal identifier of the next available sheet in this workbook.

 

Note: the numbering here should be the index of the next available sheet in the workbook in a 1-based index system.

 

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

minRId (Minimum Revision Id)

The lowest revision id that belongs to this header.

 

Note: this can be used when, given a revision ID, the spreadsheet application needs to determine which revision log to access.

 

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

userName (User Name)

A string representing the name of the user making the revision..

 

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

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

<complexType name="CT_RevisionHeader">

   <sequence>

   <element name="sheetIdMap" minOccurs="1" maxOccurs="1" type="CT_SheetIdMap"/>

   <element name="reviewedList" minOccurs="0" maxOccurs="1" type="CT_ReviewedRevisions"/>

   <element name="extLst" minOccurs="0" type="CT_ExtensionList"/>

   </sequence>

   <attribute name="guid" type="ST_Guid" use="required"/>

   <attribute name="dateTime" type="xsd:dateTime" use="required"/>

   <attribute name="maxSheetId" type="xsd:unsignedInt" use="required"/>

   <attribute name="userName" type="ST_Xstring" use="required"/>

   <attribute ref="r:id" use="required"/>

   <attribute name="minRId" type="xsd:unsignedInt" use="optional"/>

   <attribute name="maxRId" type="xsd:unsignedInt" use="optional"/>

</complexType>