Message-ID: <1126014472.7851.1711624235113.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_7850_1844089368.1711624235113" ------=_Part_7850_1844089368.1711624235113 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html Anchor

Anchor

Description

=20

An anchor represents the position of a floating (non-cell data) object w= ithin a spreadsheet. The position is maintained as a row number + a percent= age of the row's width and a column number + a percentage of the column's h= eight.

=20
C#
=20
 public sealed class Anchor
=20
=20
vb.net
=20
Public NotInheritable Class Anchor
=20
=20

Remarks

To create an=20 Anchor object, use=20 Worksh= eet.CreateAnchor or=20 Cell.C= reateAnchor.=20

Examples

=20
C#
=20

          ExcelApplication xla =3D new ExcelApplication();
          Workbook wb =3D xla.Create();
          Worksheet ws =3D wb.Worksheets[0];
          Anchor anc =3D ws.CreateAnchor(2, 4, 0, 0);
        
=20
=20
vb.net
=20

          Dim xla As New ExcelApplication()
          Dim wb As Workbook =3D xla.Create()
          Dim ws As Worksheet =3D wb.Worksheets(0)
          Dim anc As Anchor =3D ws.CreateAnchor(2, 4, 0, 0)
        
=20
=20

Properties

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20

Name

Description

Column=

Returns the 0-based number of the column contain= ing the anchor.

Offse= tX

Returns the X offset from the left side of the c= olumn containing the anchor, as a percentage of column width.

Offse= tY

Returns the Y offset from the top of the row con= taining the anchor, as a percentage of row height.

Row

Returns the 0-based number of the row containing= the anchor..
------=_Part_7850_1844089368.1711624235113--