FloatingObject.Placement Property
Gets or sets the behavior of the floating object regarding the cells below.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v19.1.Core.dll
Declaration
Property Value
Type | Description |
---|---|
Placement | A Placement enumeration value specifying how the floating object should behave when the underlying cells are resized or moved. |
Example
Note
A complete sample project is available at https://github.com/DevExpress-Examples/winforms-spreadsheetcontrol-api-part-2-e4832
' 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