The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+
Row

FloatingObject.Placement Property

Gets or sets the behavior of the floating object regarding the cells below.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v19.2.Core.dll

Declaration

Placement Placement { get; set; }
Property Placement As Placement
Placement Placement { get; set; }
Property Placement As Placement
Placement Placement { get; set; }
Property Placement As Placement

Property Value

Type Description
Placement

A Placement enumeration value specifying how the floating object should behave when the underlying cells are resized or moved.

Property Value

Type Description
Placement

A Placement enumeration value specifying how the floating object should behave when the underlying cells are resized or moved.

Property Value

Type Description
Placement

A Placement enumeration value specifying how the floating object should behave when the underlying cells are resized or moved.

Examples

' Set the measurement unit to Millimeter.
workbook.Unit = DevExpress.Office.DocumentUnit.Millimeter
workbook.Worksheets.ActiveWorksheet.DefaultRowHeight = 20
workbook.Worksheets.ActiveWorksheet.DefaultColumnWidth = 20

workbook.BeginUpdate()
Try
    Dim worksheet As Worksheet = workbook.Worksheets(0)
    ' Insert pictures.
    Dim pic As Picture = worksheet.Pictures.AddPicture("Pictures\x-spreadsheet.png", worksheet.Cells("A1"))
    worksheet.Pictures.AddPicture("Pictures\x-spreadsheet.png", worksheet.Cells("A1"))
    ' Specify picture name.
    pic.Name = "Logo"
    pic.AlternativeText = "Spreadsheet logo"
    ' Move a picture.
    pic.Move(30, 50)
    ' Move and size the picture with underlying cells. 
    pic.Placement = Placement.MoveAndSize
    worksheet.Rows(1).Height += 20
    worksheet.Columns("D").Width += 20
    ' Move another picture to illustrate OffsetX, OffsetY properties.
    worksheet.Pictures(1).Move(pic.OffsetY, pic.OffsetX)
Finally
    workbook.EndUpdate()
End Try
See Also