[Expand]General Information
[Collapse]WinForms Controls
 [Expand]What's Installed
 [Expand]Build an Application
 [Collapse]Controls and Libraries
  [Expand]Forms and User Controls
  [Expand]Messages, Notifications and Dialogs
  [Expand]Editors and Simple Controls
  [Expand]Ribbon, Bars and Menu
  [Expand]Application UI Manager
  [Expand]Docking Library
  [Expand]Data Grid
  [Expand]Vertical Grid
  [Expand]Property Grid
  [Expand]Pivot Grid
  [Expand]Tree List
  [Expand]Chart Control
  [Expand]Map Control
   [Expand]Product Information
    Product Structure
    Getting Started
   [Expand]Spreadsheet Document
    Supported Formats
   [Expand]Cell Basics
   [Expand]Spreadsheet Formulas
    Defined Names
    Data Binding
    Data Validation
   [Expand]Data Presentation
    Data Grouping
   [Expand]Pivot Table Overview
   [Collapse]Shapes, Pictures, Charts
     Charting Overview
     Chart Elements
     Create and Modify a Chart Programmatically
   [Expand]Mail Merge Overview
    Find and Replace
   [Expand]Visual Elements
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]PDF Viewer
  [Expand]TreeMap Control
  [Expand]Sunburst Control
 [Expand]Common Features
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Report and Dashboard Server
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)


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.

Expanded Working with Shapes in UI

The SpreadsheetControl enables end-users to move, resize, rotate, or remove shapes in a document.


The SpreadsheetControl does not provide user interface elements that allow end-users to insert new shapes, edit existing shapes, and change their appearance.

Expanded 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.




ShapeCollection.AddShape Creates a shape. How to: Create a Shape
ShapeCollection.AddTextBox Creates a text box. How to: Add Text to a Shape
Shape.ShapeGeometry Specifies a shape's geometry. How to: Create a Shape
ShapeCollection.GroupShapes Creates a group of shapes. How to: Create a Shape Group
ShapeCollection.UngroupShapes Splits a shape group into individual shapes. How to: Create a Shape Group
ShapeCollection.AddConnector Creates a connector. How to: Create a Shape Connector
Shape.ConnectorFormat Provides access to connector settings. How to: Create a Shape Connector
Shape.ShapeText Provides access to a shape's text format settings. How to: Add Text to a Shape
ShapeText.Characters Allows you to add text to a shape and specify its font characteristics and paragraph properties. How to: Add Text to a Shape
ShapeFormatBase.Fill Provides access to a shape's fill options. How to: Change a Shape's Fill and Outline Color
ShapeFormatBase.Outline Provides access to options used to format a shape's outline. How to: Change a Shape's Fill and Outline Color
Removes a shape from a worksheet. How to: Remove a Shape

Expanded See Also

Is this topic helpful?​​​​​​​