Page History

Creates an anchor at a specified position in the worksheet.

 public Anchor CreateAnchor(int rowNumber, int columnNumber, double offsetX, double offsetY)

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.

An Anchor object.

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.