Share via

2.6.205 CT_ThreadedComment

  • Article

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2018/threadedcomments

Referenced by: CT_ThreadedComments

This complex type specifies the properties of a threaded comment.

Child Elements:

text: An ST_Xstring ([ISO/IEC29500-1:2016] section 22.9.2.19) element that specifies the unformatted text of this comment.

mentions: A CT_ThreadedCommentMentions element that specifies a list of mentions in this comment.

extLst: A CT_ExtensionList ([ISO/IEC29500-4:2016] section A.2) element that specifies future extensibility for this element.

Attributes:

ref: An ST_Ref (section 2.7.1) attribute that specifies the reference to the cell that this threaded comment is anchored to.

dT: A dateTime ([XMLSCHEMA2/2] section 3.2.7) attribute that specifies the UTC time that the comment was authored for the first time.

personId: An ST_Guid ([ISO/IEC29500-1:2016] section 22.9.2.4) attribute that specifies a unique identifier for the comment author. This attribute MUST correspond to the id specified in CT_Person (section 2.6.203).

id: An ST_Guid ([ISO/IEC29500-1:2016] section 22.9.2.4) attribute that specifies a unique identifier for this threaded comment.

parentId: An ST_Guid ([ISO/IEC29500-1:2016] section 22.9.2.4) attribute that specifies the id of the parent comment of this comment in the comment thread.

done: A Boolean ([XMLSCHEMA2/2] section 3.2.2) attribute that specifies a flag to track resolving status of the comment.

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

 <xsd:complexType name="CT_ThreadedComment">
   <xsd:sequence>
     <xsd:element name="text" type="x:ST_Xstring" minOccurs="0" maxOccurs="1"/>
     <xsd:element name="mentions" type="CT_ThreadedCommentMentions" minOccurs="0" maxOccurs="1"/>
     <xsd:element name="extLst" minOccurs="0" maxOccurs="1"/>
   </xsd:sequence>
   <xsd:attribute name="ref" type="x:ST_Ref" use="optional"/>
   <xsd:attribute name="dT" type="xsd:dateTime" use="optional"/>
   <xsd:attribute name="personId" type="x:ST_Guid" use="required"/>
   <xsd:attribute name="id" type="x:ST_Guid" use="required"/>
   <xsd:attribute name="parentId" type="x:ST_Guid" use="optional"/>
   <xsd:attribute name="done" type="xsd:boolean" use="optional"/>
 </xsd:complexType>

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