AddShape(PSShape,Int32,Int32,Int32,Int32,Int32,Int32,Int32,Int32,Boolean) Method
In This Topic
Adds a shape to the drawing container for the sheet at the specified row and column with the top-left offset with the top-left and bottom-right cell.
Syntax
'Declaration
Public Overloads Overridable Function AddShape( _
ByVal As PSShape, _
ByVal As Integer, _
ByVal fromColumn As Integer, _
ByVal As Integer, _
ByVal fromColumnPixelOffset As Integer, _
ByVal As Integer, _
ByVal toColumn As Integer, _
ByVal As Integer, _
ByVal toColumnPixelOffset As Integer, _
ByVal As Boolean _
) As Integer
'Usage
Dim instance As SheetView
Dim shape As PSShape
Dim fromRow As Integer
Dim fromColumn As Integer
Dim fromRowPixelOffset As Integer
Dim fromColumnPixelOffset As Integer
Dim toRow As Integer
Dim toColumn As Integer
Dim toRowPixelOffset As Integer
Dim toColumnPixelOffset As Integer
Dim attachedToCell As Boolean
Dim value As Integer
value = instance.AddShape(shape, fromRow, fromColumn, fromRowPixelOffset, fromColumnPixelOffset, toRow, toColumn, toRowPixelOffset, toColumnPixelOffset, attachedToCell)
Parameters
- shape
- Shape to add
- fromRow
- Row index at which to add the shape. The fromRow parameter must be greater than or equal to 0 and less than the sheetview's row count.
- fromColumn
- Column index at which to add the shape. The fromColumn parameter must be greater than or equal to 0 and less than the sheetview's column count.
- fromRowPixelOffset
- The distance between the top boundary of the shape and the top of the specified row. The fromRowPixelOffset parameter must be greater than or equal to 0.
- fromColumnPixelOffset
- The distance between the left boundary of the shape and the left of the specified column. The fromColumnPixelOffset parameter must be greater than or equal to 0.
- toRow
- Row index that specifies the bottom boundary of the shape. The toRow parameter must be greater than or equal to fromRow and less than the sheetview's row count.
- toColumn
- Column index that specifies the right boundary of the shape. The toColumn parameter must be greater than or equal to fromColumn and less than the sheetview's column count.
- toRowPixelOffset
- The distance between the bottom boundary of the shape and the top of toRow. The toRowPixelOffset parameter must be greater than or equal to 0. If toRow is equal to fromRow, toRowPixelOffset must be greater than fromRowPixelOffset.
- toColumnPixelOffset
- The distance between the right boundary of the shape and the left of toColumn. The toColumnPixelOffset parameter must be greater than or equal to 0. If toColumn is equal to fromColumn, toColumnPixelOffset must be greater than fromColumnPixelOffset.
- attachedToCell
- Indicates whether the top-left edge of the shape must stay within the cell specified by the fromRow and fromColumn parameters and whether the bottom-right edge of the shape must stay within the cell specified by the toRow and toColumn parameters. If attachedToCell is false, when fromRowPixelOffset, fromColumnPixelOffset, toRowPixelOffset, or toColumnPixelOffset is greater than or equal to the toRow, toColumn, fromRow, or fromColumn's height or width, the top-left or bottom-right vertex of the shape boundary moves to the next row or column. This ensures that the distance between the top-left or bottom-right vertex and the top, left, bottom, or right of the specified row or column is equal to fromRowPixelOffset, fromColumnPixelOffset, toRowPixelOffset, or toColumnPixelOffset.
See Also