Two Cell Anchoring

Two Cell Anchoring describes the placement of the drawing within the spreadsheet based upon offsets as well as a specified columns and rows. 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 rows and columns are used to specify the cells to which the drawing should be anchored and upon which the resized is based. For instance, if the anchor cell changes positions then the drawing can be moved. Likewise, if the anchor cells behind the shape grow, then the shape can grow as well. The <twoCellAnchor> element is what specifies this anchoring behavior and a sample usage is shown below.

<xdr:twoCellAnchor>
  <xdr:from>
    <xdr:col>3</xdr:col>
    <xdr:colOff>447675</xdr:colOff>
    <xdr:row>8</xdr:row>
    <xdr:rowOff>28575</xdr:rowOff>
  </xdr:from>
  <xdr:to>
    <xdr:col>5</xdr:col>
    <xdr:colOff>466725</xdr:colOff>
    <xdr:row>14</xdr:row>
    <xdr:rowOff>9525</xdr:rowOff>
  </xdr:to>
  …
  </xdr:sp>
</xdr:twoCellAnchor>

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