to (Ending Anchor Point)

This element specifies the second anchor point for the drawing element. This will be used to anchor the bottom and right sides of the shape within the spreadsheet. That is when the cell that is specified in the to element is adjusted, the shape will also be adjusted.

[Example: Consider the following SpreadsheetDrawingML

<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 macro="" textlink="">

...

</xdr:sp>

<xdr:clientData/>

</xdr:twoCellAnchor>

The above example shows the second anchor point being specified via the to element. End example]

Parent Elements

twoCellAnchor (§5.6.2.32)

 

Child Elements	Subclause
col (Column))	§5.6.2.10
colOff (Column Offset)	§5.6.2.11
row (Row)	§5.6.2.26
rowOff (Row Offset)	§5.6.2.27

The following XML Schema fragment defines the contents of this element:

<complexType name="CT_Marker">

   <sequence>

   <element name="col" type="ST_ColID"/>

   <element name="colOff" type="a:ST_Coordinate"/>

   <element name="row" type="ST_RowID"/>

   <element name="rowOff" type="a:ST_Coordinate"/>

   </sequence>

</complexType>