[Table of Contents] [docx version]
Error! No text of specified style in document.
from (Starting Anchor Point)
This element specifies the first anchor point for the drawing element. This will be used to anchor the top and left sides of the shape within the spreadsheet. That is when the cell that is specified in the from 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 first anchor point being specified via the from element. End example]
Parent Elements |
oneCellAnchor (§5.6.2.23); 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>