Actions covered here:
The table below lists the supported drawing object types and methods used to create them.
Use an API from the table below to define a drawing object's location.
|FloatingObject.Move||Moves a floating object by a specified offset.|
|FloatingObject.Left||Gets or sets the distance from the left edge of the worksheet to the top left corner of the drawing object.|
|FloatingObject.OffsetX||Specifies a distance between the top left corner of the floating object and the left edge of the cell where the top left corner of the floating object is located.|
|FloatingObject.Top||Defines the distance between the top edge of the worksheet and the top left corner of the floating object.|
|FloatingObject.OffsetY||Gets a distance between the top left corner of the floating object to the top edge of the cell where the top left corner of the floating object is located.|
|FloatingObject.TopLeftCell||Specifies a cell where the top left corner of a floating object is located.|
|FloatingObject.BottomRightCell||Gets or sets a cell where the bottom right corner of a floating object is located.|
|Shape.ZOrderPosition||Retrieves the position of the current drawing object in the Z-order. The default shapes' Z-order value is equal to their numerical order in the ShapeCollection.|
|ShapeCollection.NormalizeZOrder||Resets the shapes' Z-order.|
The image below illustrates the distances this API specifies.
You can specify the drawing object's size and rotation angle using the following properties.
End-users can resize or rotate a drawing object with special handles, which are visible for selected objects.
The FloatingObject.Placement property determines whether the drawing object moves and/or resizes together with underlying cells. For example, set the Placement property to Placement.MoveAndSize to make the drawing object move and resize with cells, as shown below.
You can provide a hyperlink to the drawing object. When an end-user clicks the drawing object, the link navigates to a certain location on the Internet, or to a file, to a place in a workbook, or it sends an email. Use the Shape.InsertHyperlink method to specify a hyperlink for a drawing object, and use the Shape.RemoveHyperlink method to delete a hyperlink. Refer to the How to: Add a Hyperlink to a Picture topic for a code example.
The following methods allow you to remove a drawing object.
ShapeCollection.RemoveAt - removes the element at the specified index.