IXlPicture.SetAbsoluteAnchor(Int32, Int32, Int32, Int32) Method

Anchors an IXlPicture object to an absolute position in a worksheet.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v23.2.Core.dll

NuGet Package: DevExpress.Printing.Core

Declaration

C#

void SetAbsoluteAnchor(
    int x,
    int y,
    int width,
    int height
)

VB.NET

Sub SetAbsoluteAnchor(
    x As Integer,
    y As Integer,
    width As Integer,
    height As Integer
)

Parameters

Name	Type	Description
x	Int32	A Int32 value that specifies the distance from the left edge of the worksheet in pixels.
y	Int32	A Int32 value that specifies the distance from the top edge of the worksheet in pixels.
width	Int32	A Int32 value that is the desired width of the picture in pixels.
height	Int32	A Int32 value that is the desired height of the picture in pixels.

Remarks

Use the SetAbsoluteAnchor method to specify an absolute position for a picture in a worksheet. This position is defined by the x and y coordinates that represent offsets from the left and top edges of the worksheet to the top-left corner of the picture. The IXlPicture.AnchorType for the inserted picture will be set to XlAnchorType.Absolute. The picture will not move or resize with the underlying cells.

For more information on how to add a picture to a worksheet and specify its location, refer to the How to: Insert and Position a Picture in a Worksheet example.