FormControlCollection.AddButton(Single, Single, Single, Single) Method

Creates a button form control in the specified worksheet area.

Assembly : DevExpress.Spreadsheet.v25.2.Core.dll

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

C#
VB.NET

csharp

ButtonFormControl AddButton(
    float x,
    float y,
    float width,
    float height
)

Function AddButton(
    x As Single,
    y As Single,
    width As Single,
    height As Single
) As ButtonFormControl

Parameters

Name	Type	Description
x	Single

The distance from the left of the worksheet. The ISpreadsheetComponent.Unit property specifies the unit of measurement.

| | y | Single |

The distance from the top of the worksheet. The ISpreadsheetComponent.Unit property specifies the unit of measurement.

| | width | Single |

The button width.

| | height | Single |

The button height.

Returns

Type	Description
ButtonFormControl

A button form control.

Remarks

Example

The code sample below creates a button form control:

C#
VB.NET

csharp

Workbook workbook = new Workbook();
workbook.LoadDocument("Document.xlsx");

var formControls = workbook.Worksheets[0].FormControls;

var buttonFormControl = formControls.AddButton(20, 20, 400, 200);
buttonFormControl.PlainText = "Click Here";
buttonFormControl.PrintObject = false;

Dim workbook As New Workbook()
workbook.LoadDocument("Document.xlsx")

Dim formControls = workbook.Worksheets(0).FormControls

Dim buttonFormControl = formControls.AddButton(20, 20, 400, 200)
buttonFormControl.PlainText = "Click Here"
buttonFormControl.PrintObject = False