Page History

{description}
{excerpt}Creates an anchor at a specified position in the worksheet. 
{excerpt}
{signature:C#}
 public Anchor CreateAnchor(int rowNumber, int columnNumber, double offsetX, double offsetY)

{signature}{signature:vb.net

}
Public Function CreateAnchor(ByVal rowNumber As Integer, ByVal columnNumber As Integer, ByVal offsetX As Double, ByVal offsetY As Double) As Anchor

...

The 0-based row number of the cell in which the anchor will be positioned.

...

The 0-based column number of the cell in which the anchor will be positioned.

...

The X offset from the cell's left side as a percentage of the cell's width. If this worksheet is a chartsheet, this value is a percentage of the chart's width. This value must be between 0 and 100.

...

The Y offset from the top of the cell as a percentage of the cell's height. If this worksheet is a chartsheet, this value is a percentage of the chart's height. This value must be between 0 and 100.

{signature}
{parameters}
{param:rowNumber}The 0\-based row number of the cell in which the anchor will be positioned.{param}
{param:columnNumber}The 0\-based column number of the cell in which the anchor will be positioned.{param}
{param:offsetX}The X offset from the cell's left side as a percentage of the cell's width.  If this worksheet is a chartsheet, this value is a percentage of the chart's width. This value must be between 0 and 100.{param}
{param:offsetY}The Y offset from the top of the cell as a percentage of the cell's height.  If this worksheet is a chartsheet, this value is a percentage of the chart's height. This value must be between 0 and 100.{param}
{returns}An [Anchor|Anchor] object.{returns}
{remarks}
An anchor represents the position of a floating \(non\-cell data\) object within a spreadsheet. The position is maintained as a row number \+ a percentage of the row's width and a column number \+ a percentage of the column's height.

If this Worksheet is actually a Chartsheet, the rowNumber and columnNumber values are disregarded and the offsetX and offsetY values are interperted to be a percentage of the Chart's width and height, respectivly.

{remarks}
{example}{code:csharp|title=C#}
Anchor anch = ws.CreateAnchor(4, 1, 30, 50);

{code}
{code:vb.net

|title=vb.net

}
Dim anch As Anchor = ws.CreateAnchor(4, 1, 30, 50){code}

{example}