.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
Row

FloatingObject.Move(Single, Single) Method

Moves a floating object by a specified offset.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v20.1.Core.dll

Declaration

void Move(
    float rowOffset,
    float columnOffset
)
Sub Move(
    rowOffset As Single,
    columnOffset As Single
)

Parameters

Name Type Description
rowOffset Single

A Single that is the horizontal (column) offset measured in units specified by the ISpreadsheetComponent.Unit property.

columnOffset Single

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

Remarks

The image below illustrates the distances used to specify a picture's placement on a worksheet.

Shape_Distances

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