Office Open XML
20 DrawingML - Framework Reference Material
20.5 DrawingML - SpreadsheetML Drawing

20.5 DrawingML - SpreadsheetML Drawing

Within a SpreadsheetML document, it is possible to include graphical DrawingML objects:

When these objects are present in a spreadsheet document, it is necessary to include information which specifies how the objects shall be positioned relative to the parent worksheet. [Example: Whether the object is anchored to a specific row, whether it resizes with cells, and so on. end example]

The SpreadsheetML Drawing namespace acts in this capacity, specifying all information necessary to anchor and display DrawingML objects within a spreadsheet document.

[Example: Consider a DrawingML picture which must be anchored to a specific cell for its top left and bottom right corners, resizing as those cells are relocated. This object would be specified as follows:

<xdr:twoCellAnchor>
  <xdr:from>
    …
  </xdr:from>
  <xdr:to>
    …
  </xdr:to>
  <xdr:graphicFrame>
    …
    <a:graphic>
      <a:graphicData
        uri="http://purl.oclc.org/ooxml/drawingml/diagram">
        <dgm:relIds xmlns:dgm="…" xmlns:r="…" r:dm="rId1" r:lo="rId2"
            r:qs="rId3" r:cs="rId4" />
      </a:graphicData>
    </a:graphic>
  </xdr:graphicFrame>
</xdr:twoCellAnchor>

The twoCellAnchor element (20.5.2.33) specifies that this object anchored to the cells specified by the to

(20.5.2.32) and from (20.5.2.15) elements. end example]

Subsections

Last updated on