Spreadsheet Shapes
- 2 minutes to read
The WinForms Spreadsheet control allows you to view, print, and export documents that contain shapes to PDF/HTML. All shape types are supported: from simple lines and rectangles, to 3-D shapes with advanced effects.
Work with Shapes in UI
The SpreadsheetControl enables end-users to move, resize, rotate, or remove shapes in a document.
Note
The SpreadsheetControl does not provide user interface elements that allow end-users to insert new shapes, edit existing shapes, and change their appearance.
Shape API
An individual shape (Shape) is a member of the Worksheet.Shapes collection. The ShapeCollection collection stores all drawing objects embedded in a worksheet (shapes, pictures, and charts). You can access an existing shape by its index in the shape collection or using the ShapeCollection.GetShapeById method. The Shape.ShapeType property allows you to distinguish between different drawing object types within a worksheet.
The ShapeCollection and Shape interfaces provide methods and properties designed to manipulate shapes in a document.
Member | Description | Example |
|---|---|---|
Creates a shape. | ||
Creates a text box. | ||
Specifies a shape’s geometry. | ||
Creates a group of shapes. | ||
Splits a shape group into individual shapes. | ||
Creates a connector. | ||
Provides access to connector settings. | ||
Provides access to a shape’s text format settings. | ||
Allows you to add text to a shape and specify its font characteristics and paragraph properties. | ||
Provides access to a shape’s fill options. | ||
Provides access to options used to format a shape’s outline. | ||
Removes a shape from a worksheet. |