XlAnchorType Enum

Lists anchoring types used to position an IXlPicture object in a worksheet or specifies how a picture should be moved and resized when a two cell anchoring is used.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v18.1.Core.dll

Declaration

C#

public enum XlAnchorType

VB.NET

Public Enum XlAnchorType

Members

Name	Description
TwoCell	Two Cell Anchoring. The picture moves and/or resizes with the underlying cells as specified by the IXlPicture.AnchorBehavior property.
OneCell	One Cell Anchoring. The picture moves with the anchor cell, but its size remains the same.
Absolute	Absolute Anchoring. The picture does not move or resize with the underlying cells.

Related API Members

The following properties accept/return XlAnchorType values:

• IXlPicture.AnchorBehavior
• IXlPicture.AnchorType

Remarks

The values listed by this enumeration are used by the following properties:

• IXlPicture.AnchorType, to specify the anchoring type used to position a picture within a worksheet.
• IXlPicture.AnchorBehavior, to specify the positioning and resizing behavior of a picture which is anchored to two cells in a worksheet.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the XlAnchorType enum.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

excel-export-api-examples-t253492/CS/XLExportExamples/SpreadsheetActions/PictureActions.cs#L39

    picture.Image = Image.FromFile(Path.Combine(imagesPath, "image1.jpg"));
    picture.SetTwoCellAnchor(new XlAnchorPoint(1, 1, 0, 0), new XlAnchorPoint(6, 11, 2, 15), XlAnchorType.TwoCell);
}

VB.NET

excel-export-api-examples-t253492/VB/XLExportExamples/SpreadsheetActions/PictureActions.vb#L36

    picture.Image = Image.FromFile(Path.Combine(imagesPath, "image1.jpg"))
    picture.SetTwoCellAnchor(New XlAnchorPoint(1, 1, 0, 0), New XlAnchorPoint(6, 11, 2, 15), XlAnchorType.TwoCell)
End Using