Xceed Workbooks for .NET v3.0 Documentation
Xceed.Workbooks.NET Assembly / Xceed.Workbooks.NET Namespace / PositionedElement Class / AnchorPosition Property


    AnchorPosition Property
    Gets or sets the position of the Anchor in the Worksheet.
    Syntax
    'Declaration
     
    
    Public Property AnchorPosition As CellRange
     
    'Usage
     
    
    Dim instance As PositionedElement
    Dim value As CellRange
     
    instance.AnchorPosition = value
     
    value = instance.AnchorPosition
    Remarks

    This position is determined by a StartingElement & an EndingElement, which sets a CellRange.

    The StartingElement is the address corresponding to the inner top left corner of the top left Cell in the CellRange.

    The EndingElement is the address corresponding to the outer top left corner of the bottom right Cell in the CellRange.

    For example, if the range is determined by the addresses "A2 : E5", the Picture will start at the inner top left corner of the A2 Cell & pass through it until it reaches the outer corner of the E5 Cell, which it will only touch & not pass through.

    If the StartingElementEndingElement have the same value, a OneCellAnchor will be created.

    Note that setting a value in this property will remove the value in the AbsolutePosition property because an anchor using said property is an AbsoluteAnchor, which doesn't use the AnchorPosition property.

    Also note that for this property to work, the CellRange must be located within the same Worksheet as the PositionedElement

     

     

    Requirements

    Target Platforms: Windows 11, Windows 10, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

    See Also