officefileapi-devexpress-dot-spreadsheet-dot-floatingobject-2371f445.md
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.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
float OffsetX { get; }
ReadOnly Property OffsetX As Single
| Type | Description |
|---|---|
| Single |
A Single that is the horizontal offset measured in units specified by the ISpreadsheetComponent.Unit property.
|
To get the distance from the left edge of the worksheet, use the FloatingObject.Left property.
// 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();
}
' 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
The following code snippet (auto-collected from DevExpress Examples) contains a reference to the OffsetX property.
Note
The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.
// Move another picture to illustrate OffsetX, OffsetY properties.
worksheet.Pictures[1].Move(pic.OffsetY, pic.OffsetX);
}
' Move another picture to illustrate OffsetX, OffsetY properties.
worksheet.Pictures(1).Move(pic.OffsetY, pic.OffsetX)
Finally
See Also