SetBoundsInTwips(Worksheet,Rect,Boolean,PositioningOptions) Method

Sets the bounds of the shape in twips (1/20th of a point).

Syntax

Visual Basic

'Declaration
 
Public Overloads Sub SetBoundsInTwips( _
   ByVal worksheet As Worksheet, _
   ByVal bounds As Rect, _
   ByVal maintainAspectRatio As Boolean, _
   ByVal options As PositioningOptions _
) 

C#

public void SetBoundsInTwips( 
   Worksheet worksheet,
   Rect bounds,
   bool maintainAspectRatio,
   PositioningOptions options
)

Parameters

worksheet

The worksheet on which the shape should be placed.

bounds

The new bounds where the shape should be placed.

maintainAspectRatio

The value indicating whether the image's aspect ratio should be maintained.

options

The options to use when setting the bounds of the shape.

Exceptions

Exception	Description
System.ArgumentNullException	worksheet is null.

Remarks

The shape will only be position at the specified bounds while the worksheet remains in the current configuration. If any rows or columns before or within the shape are resized, the shape will no longer be placed at the bounds specified.

If maintainAspectRatio is False, this just calls WorksheetShape.SetBoundsInTwips on its base class.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2