Back to Devexpress

Spreadsheet Shapes

wpf-120316-controls-and-libraries-spreadsheet-charts-and-graphics-shapes.md

latest5.5 KB
Original Source

Spreadsheet Shapes

  • Apr 15, 2021
  • 2 minutes to read

The WPF 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 banners and callouts.

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

|

Property

|

Description

|

Example

| | --- | --- | --- | |

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

| |

ShapeCollection.RemoveAt,

Shape.Delete

|

Removes a shape from a worksheet.

|

How to: Remove A Shape

|

See Also

Charts and Graphics in Spreadsheet Documents