FloatingObject.OffsetX Property
Gets a distance from the top left corner of the floating to the left edge of the cell where the top left corner of the floating object is located.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v19.1.Core.dll
Declaration
Property Value
Type | Description |
---|---|
Single | A Single that is the horizontal offset measured in units specified by the ISpreadsheetComponent.Unit property. |
Remarks
To get the distance from the left edge of the worksheet, use the FloatingObject.Left property.
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