Wiki Markup |
---|
{description} {excerpt}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.{excerpt} {signature:C#} public sealed class Anchor {signature}{signature:vb.net} Public NotInheritable Class Anchor {signature} {remarks}To create an [Anchor|Anchor] object, use [Worksheet.CreateAnchor|Worksheet.CreateAnchor(Int32, Int32, Double, Double)] or [Cell.CreateAnchor|Cell.CreateAnchor(Int32, Int32)]. {remarks} {example}{code:csharp|title=C#} ExcelApplication xla = new ExcelApplication(); Workbook wb = xla.Create(); Worksheet ws = wb.Worksheets[0]; Anchor anc = ws.CreateAnchor(2, 4, 0, 0); {code} {code:vbnet|title=vb.net} Dim xla As New ExcelApplication() Dim wb As Workbook = xla.Create() Dim ws As Worksheet = wb.Worksheets(0) Dim anc As Anchor = ws.CreateAnchor(2, 4, 0, 0) {code} {example} {properties} ||Name||Description|| |[Column|Anchor.Column]|{excerpt-include:Anchor.Column|nopanel=true}| |[OffsetX|Anchor.OffsetX]|{excerpt-include:Anchor.OffsetX|nopanel=true}| |[OffsetY|Anchor.OffsetY]|{excerpt-include:Anchor.OffsetY|nopanel=true}| |[Row|Anchor.Row]|{excerpt-include:Anchor.Row|nopanel=true}| {scrollbar} |
Page History
Overview
Content Tools