Back to Devexpress

FormControlCollection.AddCheckBox(Cell, Single, Single) Method

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

latest2.9 KB
Original Source

FormControlCollection.AddCheckBox(Cell, Single, Single) Method

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

Namespace : DevExpress.Spreadsheet

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

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

csharp
CheckBoxFormControl AddCheckBox(
    Cell topLeftCell,
    float width,
    float height
)
vb
Function AddCheckBox(
    topLeftCell As Cell,
    width As Single,
    height As Single
) As CheckBoxFormControl

Parameters

NameTypeDescription
topLeftCellCell

A cell where the top left corner of the form control is located.

| | width | Single |

The form control width.

| | height | Single |

The form control height.

|

Returns

TypeDescription
CheckBoxFormControl

The check box form control.

|

Remarks

Example

The code sample below creates a checkbox form control:

csharp
using DevExpress.Spreadsheet;

Workbook workbook = new Workbook();
workbook.LoadDocument("Document.xlsx");
var topCell = workbook.Worksheets[0].Cells["B2"];
var checkBoxControl = formControls.AddCheckBox(topCell, 200, 100);
checkBoxControl.CheckState = FormControlCheckState.Checked;
checkBoxControl.PlainText = "Reviewed";
vb
Imports DevExpress.Spreadsheet

Dim workbook As New Workbook()
workbook.LoadDocument("Document.xlsx")
Dim topCell = workbook.Worksheets(0).Cells("B2")
Dim checkBoxControl = formControls.AddCheckBox(topCell, 200, 100)
checkBoxControl.CheckState = FormControlCheckState.Checked
checkBoxControl.PlainText = "Reviewed"

Note

The FormControlCollection.AddCheckBox method call adds a new item to both FormControlCollection and ShapeCollection.

See Also

FormControlCollection Interface

FormControlCollection Members

DevExpress.Spreadsheet Namespace