12.3.3 Comments Part

Content Type:

application/vnd.openxmlformats-officedocument.spreadsheetml.comments+xml

Root Namespace:

http://purl.oclc.org/ooxml/spreadsheetml/main

Source Relationship:

http://purl.oclc.org/ooxml/officeDocument/relationships/comments

An instance of this part type contains all the comments for a given worksheet, as well as the names of the authors of those comments.

A package shall contain exactly one Comments part for each worksheet that contains one or more comments. If a Comments part exists, it shall be the target of an implicit relationship from the Workbook part (12.3.23).

[Example: The following Worksheet part-relationship item contains a relationship to the Comments part, which is stored in the ZIP item comments2.xml:

<Relationships xmlns="…">
  <Relationship Id="rId2"
    Type="http://…/comments" Target="../comments2.xml"/>
</Relationships>

end example]

The root element for a part of this content type shall be comments.

[Example: This Comments part results from a workbook that has one or more comments from each of two people: James Jones and Mary Smith:

<comments xmlns:st="…" >
  <authors>
    <author>James Jones</author>
    <author>Mary Smith</author>
  </authors>
  <commentList>
    <comment r="C7" authorId="0">
      <text>
        <st:r>
          <st:rPr>
            …
          </st:rPr>
          <st:t>James Jones:</st:t>
        </st:r>
        <st:r>
          <st:rPr>
            …
          </st:rPr>
          <st:t>Check that this date
        </st:r>
      </text>
    </comment>
    <comment r="E7" authorId="1">
      …
    </comment>
  </commentList>
</comments>

end example]

A Comments part shall be located within the package containing the relationships part (expressed syntactically, the TargetMode attribute of the Relationship element shall be Internal).

A Comments part shall not implicit or explicit relationships to any part defined by ISO/IEC 29500.