FormControlCollection.AddButton(Cell, Single, Single) Method

Creates a button form control so that the top left corner of the button is located at the specified cell.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

ButtonFormControl AddButton(
    Cell topLeftCell,
    float width,
    float height
)

VB.NET

Function AddButton(
    topLeftCell As Cell,
    width As Single,
    height As Single
) As ButtonFormControl

Parameters

Name	Type	Description
topLeftCell	Cell	A cell where the top left corner of the form control is located.
width	Single	The button width.
height	Single	The button height.

Returns

Type	Description
ButtonFormControl	A button form control.

Remarks

The code sample below creates a button form control:

C#

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

var topLeft = workbook.Worksheets[0].Cells["B2"];
var formControls = workbook.Worksheets[0].FormControls;

var buttonFormControl = formControls.AddButton(topLeft, 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 topLeft = workbook.Worksheets(0).Cells("B2")
Dim buttonFormControl = formControls.AddButton(topLeft, 400,200)
buttonFormControl.PlainText = "Click Here"
buttonFormControl.PrintObject = False