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

Creates a button form control in the specified worksheet area.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

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

VB.NET

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#

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;

VB.NET

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