[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

rcmt (Revision Cell Comment)

This element represents a revision record of a cell comment change.

Parent Elements

revisions3.11.1.16)

 

Attributes

Description

action (User Action)

An enumeration identifying what kind of an operation the user performed on the comment.

 

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

alwaysShow (Always Show Comment)

A Boolean value indicating that the user has set this comment to always be visible. True if the comment is set to always be visible, false otherwise.

 

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

author (Author)

A string representing the name of the author who changed this comment.

 

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

cell (Cell)

An A-1 style reference to the cell where the comment was changed.

 

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

guid (GUID)

A globally unique identifier of this comment.

 

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

hiddenColumn (Hidden Column)

A Boolean value indicating that the comment belongs to a cell in a hidden column. True if the comment is in a hidden column, false otherwise.

 

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

hiddenRow (Comment In Hidden Row)

A Boolean value indicating that the comment belongs to a cell in a hidden row. True if the comment is in a hidden row, false otherwise.

 

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

newLength (New Comment Length)

Length of the comment text added in this revision.

 

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

old (Old Comment)

An ignorable Boolean value used for backwards compatibility that indicates that the original comment was created by a legacy spreadsheet application.

 

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

oldLength (Original Comment Length)

Length of the comment before this revision was made.

 

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

sheetId (Sheet Id)

An integer representing the internal id of the sheet on which the revision occurred.

 

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_RevisionComment">

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

   <attribute name="cell" type="ST_CellRef" use="required"/>

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

   <attribute name="action" type="ST_RevisionAction" default="add"/>

   <attribute name="alwaysShow" type="xsd:boolean" use="optional" default="false"/>

   <attribute name="old" type="xsd:boolean" use="optional" default="false"/>

   <attribute name="hiddenRow" type="xsd:boolean" use="optional" default="false"/>

   <attribute name="hiddenColumn" type="xsd:boolean" use="optional" default="false"/>

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

   <attribute name="oldLength" type="xsd:unsignedInt" default="0"/>

   <attribute name="newLength" type="xsd:unsignedInt" default="0"/>

</complexType>