ShapeCollection.AddTextBox(Single, Single, Single, Single, String) Method

Inserts a text box.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v24.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

Shape AddTextBox(
    float x,
    float y,
    float width,
    float height,
    string text
)

VB.NET

Function AddTextBox(
    x As Single,
    y As Single,
    width As Single,
    height As Single,
    text As String
) As Shape

Parameters

Name	Type	Description
x	Single	A Single value indicating the distance from the left of the worksheet.
y	Single	A Single value indicating the distance from the top of the worksheet.
width	Single	A Single value that is the text box’s width.
height	Single	A Singlevalue that is the text box’s height.
text	String	A string value that is the text box’s content.

Returns

Type	Description
Shape	A Shape object that is the resulting text box.

Remarks

Note

The ISpreadsheetComponent.Unit property determines the units of linear dimensions (x, y, width, height).

The following properties help you determine whether the current Shape object is a text box:

• The Shape.ShapeType property is ShapeType.Shape.
• The ShapeGeometry.Preset property returns ShapeGeometryPreset.Rectangle.
• The ShapeText.HasText property is true.

Change the text box’s fill and outline settings using the ShapeFormatBase.Fill and ShapeFormatBase.Outline properties.

Use the Shape.ShapeText property to access the shape’s text options.

The Shape.Rotation property allows you to define the text box’s rotation angle.

Delete the text box using the ShapeCollection.RemoveAt or Shape.Delete method.

Example

The code sample below shows how to insert, rotate and color a text box:

C#

Shape textBox = worksheet.Shapes.AddTextBox(50, 120, 500, 100, "Spreadsheet");
textBox.Fill.SetSolidFill(Color.PowderBlue);
textBox.Rotation = 30;

VB.NET

Dim textBox As Shape = worksheet.Shapes.AddTextBox(50, 120, 500, 100, "Spreadsheet")
textBox.Fill.SetSolidFill(Color.PowderBlue)
textBox.Rotation = 30