FloatingObject.Placement Property

Gets or sets the behavior of the floating object regarding the cells below.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

Placement Placement { get; set; }

VB.NET

Property Placement As Placement

Property Value

Type	Description
Placement	A Placement enumeration value specifying how the floating object should behave when the underlying cells are resized or moved.

Available values:

Name	Description
MoveAndSize	The object (picture) moves and sizes with the underlying cells.
Move	The object (picture) moves with the underlying cells.
FreeFloating	The object (picture) does not move or size with cells.

Example

View Example

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();
}

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the Placement 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.

C#

spreadsheet-document-api-examples-part2/CS/SpreadsheetDocServerAPIPart2/CodeExamples/PictureActions.cs#L57

// Specify picture behavior.
pic.Placement = Placement.MoveAndSize;
worksheet.Rows[5].Height += 10;

winforms-spreadsheetcontrol-api-part-2/CS/SpreadsheetControl_API_Part02/SpreadsheetActions/PictureActions.cs#L104

// Move and size the picture with underlying cells.
pic.Placement = Placement.MoveAndSize;
worksheet.Rows[1].Height += 20;

VB.NET

spreadsheet-document-api-examples-part2/VB/SpreadsheetDocServerAPIPart2/CodeExamples/PictureActions.vb#L51

' Specify picture behavior.
pic.Placement = DevExpress.Spreadsheet.Placement.MoveAndSize
worksheet.Rows(CInt((5))).Height += 10

winforms-spreadsheetcontrol-api-part-2/VB/SpreadsheetControl_API_Part02/SpreadsheetActions/PictureActions.vb#L97

' Move and size the picture with underlying cells.
pic.Placement = Placement.MoveAndSize
worksheet.Rows(1).Height += 20

wpf-spreadsheetcontrol-api-part-2/VB/SpreadsheetControl_WPF_API_Part02/SpreadsheetActions/ShapeActions.vb#L91

' Change picture behavior so it will move and size with underlying cells.
pic.Placement = Placement.MoveAndSize
worksheet.Rows(5).Height += 10