FloatingObject.Move(Single, Single) Method

Moves a floating object by a specified offset.

Namespace: DevExpress.Spreadsheet

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

Declaration

C#

void Move(
    float rowOffset,
    float columnOffset
)

VB.NET

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.

Example

Note

A complete sample project is available at https://github.com/DevExpress-Examples/winforms-spreadsheetcontrol-api-part-2-e4832

PictureActions.vb

' 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

PictureActions.cs

// 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
{
    Worksheet worksheet = workbook.Worksheets[0];
    // Insert pictures.
    Picture pic = 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();
}