DrawingML - SpreadsheetML Drawing

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

  • Pictures (§5.2)

  • Locked Canvases (§5.4)

  • Diagrams (§5.9)

  • Charts (§5.7)

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.

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

example:
<xdr:twoCellAnchor>
  <xdr:from>
    ...
  </xdr:from>
  <xdr:to>
    ...
  </xdr:to>
  <xdr:graphicFrame>
    ...
    <a:graphic>
      <a:graphicData 
         uri="http://schemas.openxmlformats.org/drawingml/2006/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 (§5.6.2.32) specifies that this object anchored to the cells specified by the <to>5.6.2.31) and <from>5.6.2.14) elements. ]