[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
This element represents a single user entered comment.. Each comment shall have an author and can optionally contain richly formatted text.
|
Parent Elements |
|
commentList (§3.7.4) |
|
Child Elements |
Subclause |
|
text (Comment Text) |
§3.7.6 |
|
Attributes |
Description |
|
authorId (Author Id) |
Required. An unsigned integer which is used as the zero based index into the list of authors for this set of comments.
The possible values for this attribute are defined by the XML Schema unsignedInt datatype. |
|
guid (Unique Identifier for Comment) |
Unique identifier for this comment. The attribute is required and shall be unique across all comments in shared workbooks.
The possible values for this attribute are defined by the ST_Guid simple type (§3.18.41). |
|
ref (Cell Reference) |
Required. A string that serves as the A1 style reference to the cell that the comment is associated with. May only reference a single cell, not a range of cells, since comments are on a per cell basis.
The possible values for this attribute are defined by the ST_Ref simple type (§3.18.64). |
The following XML Schema fragment defines the contents of this element:
<complexType name="CT_Comment">
<sequence>
<element name="text" type="CT_Rst" minOccurs="1" maxOccurs="1"/>
</sequence>
<attribute name="ref" type="ST_Ref" use="required"/>
<attribute name="authorId" type="xsd:unsignedInt" use="required"/>
<attribute name="guid" type="ST_Guid" use="optional"/>
</complexType>