One Cell Anchoring

One Cell Anchoring describes the placement of the drawing within the spreadsheet based upon offsets as well as a specified column and row. The offset is always in reference to the specified anchor cell and acts to offset the shape object from being exactly on top of the anchor cell. The offset information determines the actual placement of the drawing within the spreadsheet while the row and column are used to specify to which cell the drawing should be anchored. Thus, if the anchor cell changes positions then the drawing can be moved as well. The <oneCellAnchor> element is what specifies this anchoring behavior and a sample usage is shown below.

<xdr:oneCellAnchor>
  <xdr:from>
    <xdr:col>3</xdr:col>
    <xdr:colOff>333375</xdr:colOff>
    <xdr:row>8</xdr:row>
    <xdr:rowOff>28575</xdr:rowOff>
  </xdr:from>
  <xdr:ext cx="1238250" cy="1123950"/>
  …
  </xdr:sp>
</xdr:oneCellAnchor>

In this example, there is a single shape specified using one cell anchoring as its anchoring method.