Back to Devexpress

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

officefileapi-devexpress-dot-spreadsheet-dot-formcontrolcollection-dot-addbutton-x28-system-dot-single-system-dot-single-system-dot-single-system-dot-single-x29.md

latest2.9 KB
Original Source

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

Creates a button form control in the specified worksheet area.

Namespace : DevExpress.Spreadsheet

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

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

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

Parameters

NameTypeDescription
xSingle

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

TypeDescription
ButtonFormControl

A button form control.

|

Remarks

Example

The code sample below creates a button form control:

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;
vb
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

See Also

FormControlCollection Interface

FormControlCollection Members

DevExpress.Spreadsheet Namespace