Comments Part

Content Type:

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

Root Namespace:

http://schemas.openxmlformats.org/spreadsheetml/2006/main

Source Relationship:

http://schemas.openxmlformats.org/officeDocument/2006/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:

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

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

example:

<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> :</st:t>
        </st:r>
        <st:r>
          <st:rPr>
            …
          </st:rPr>
          <st:t>Check that this date is correct.</st:t>
        </st:r>
      </text>
    </comment>
    <comment r="E7" authorId="1">
      …
    </comment>
  </commentList>
</comments>

A Comments part shall be located within the package containing the source relationship (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 this Standard.