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.OffsetY Property

Gets a distance from the top left corner of the floating object to the top edge of the cell where the top left corner of the floating object is located.

Namespace: DevExpress.Spreadsheet

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

Declaration

float OffsetY { get; }
ReadOnly Property OffsetY As Single
float OffsetY { get; }
ReadOnly Property OffsetY As Single
float OffsetY { get; }
ReadOnly Property OffsetY As Single

Property Value

Type Description
Single

A Single that is the vertical offset measured in units specified by the ISpreadsheetComponent.Unit property.

Property Value

Type Description
Single

A Single that is the vertical offset measured in units specified by the ISpreadsheetComponent.Unit property.

Property Value

Type Description
Single

A Single that is the vertical offset measured in units specified by the ISpreadsheetComponent.Unit property.

Remarks

To get the distance form the top edge of the worksheet, use the FloatingObject.Top property.

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