officefileapi-devexpress-dot-spreadsheet-dot-formcontrolcollection-dot-addcombobox-x28-system-dot-single-system-dot-single-system-dot-single-system-dot-single-x29.md
Creates a combo box form control in the specified worksheet area.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
ComboBoxFormControl AddComboBox(
float x,
float y,
float width,
float height
)
Function AddComboBox(
x As Single,
y As Single,
width As Single,
height As Single
) As ComboBoxFormControl
| 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 form control width.
| | height | Single |
The form control height.
|
| Type | Description |
|---|---|
| ComboBoxFormControl |
The combo box form control.
|
The code sample below creates a combo box control:
using DevExpress.Spreadsheet;
Workbook workbook = new Workbook();
workbook.LoadDocument("Document.xlsx");
var comboBoxControl = formControls.AddComboBox(20, 20, 300, 100);
comboBoxControl.DropDownLines = 3;
comboBoxControl.SourceRange = workbook.Worksheets[0].Range["E2:E6"];
comboBoxControl.SelectedIndex = 1;
Imports DevExpress.Spreadsheet
Dim workbook As New Workbook()
workbook.LoadDocument("Document.xlsx")
Dim comboBoxControl = formControls.AddComboBox(20, 20, 300, 100)
comboBoxControl.DropDownLines = 3
comboBoxControl.SourceRange = workbook.Worksheets(0).Range("E2:E6")
comboBoxControl.SelectedIndex = 1
Note
The FormControlCollection.AddComboBox method call adds a new item to both FormControlCollection and ShapeCollection.
See Also