Gets the position of the current drawing object in the z-order.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v19.2.Core.dll
| Type | Description |
|---|---|
| Int32 | An integer that indicates the position in the z-order. |
| Type | Description |
|---|---|
| Int32 | An integer that indicates the position in the z-order. |
| Type | Description |
|---|---|
| Int32 | An integer that indicates the position in the z-order. |
When drawing objects are added to the Worksheet.Shapes collection, the ZOrderPosition value is incremented by one starting from 1. You can increase the ZOrderPosition property value to move the drawing object in front of all objects with a lower ZOrderPosition. The ShapeCollection.NormalizeZOrder method modifies ZOrderPosition values for all drawing objects in a collection so that they become a series of consecutive integers starting from 1.
A complete sample project is available at https://github.com/DevExpress-Examples/winforms-spreadsheetcontrol-api-part-2-e4832
workbook.BeginUpdate()
Try
Dim worksheet As Worksheet = workbook.Worksheets(0)
' Insert pictures.
Dim pic1 As Picture = worksheet.Pictures.AddPicture("Pictures\x-docserver.png", worksheet.Cells("B2"))
Dim pic2 As Picture = worksheet.Pictures.AddPicture("Pictures\x-spreadsheet.png", worksheet.Cells("C5"))
' Bring the first picture to front.
pic1.ZOrderPosition = 3
Finally
workbook.EndUpdate()
End Try
workbook.BeginUpdate();
try
{
Worksheet worksheet = workbook.Worksheets[0];
// Insert pictures.
Picture pic1 = worksheet.Pictures.AddPicture("Pictures\\x-docserver.png", worksheet.Cells["B2"]);
Picture pic2 = worksheet.Pictures.AddPicture("Pictures\\x-spreadsheet.png", worksheet.Cells["C5"]);
// Bring the first picture to front.
pic1.ZOrderPosition = 3;
}
finally
{
workbook.EndUpdate();
}