officefileapi-devexpress-dot-spreadsheet-dot-formcontrolcollection-dot-addcombobox-x28-devexpress-dot-spreadsheet-dot-cell-system-dot-single-system-dot-single-x29.md
Creates a combo box form control so that the top left corner of the combo box is located at the specified cell.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
ComboBoxFormControl AddComboBox(
Cell topLeftCell,
float width,
float height
)
Function AddComboBox(
topLeftCell As Cell,
width As Single,
height As Single
) As ComboBoxFormControl
| Name | Type | Description |
|---|---|---|
| topLeftCell | Cell |
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.
|
| 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 topLeftCell = workbook.Worksheets[0].Cells["B2"];
var comboBoxControl = formControls.AddComboBox(topLeftCell, 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 topLeftCell = workbook.Worksheets(0).Cells("B2")
Dim comboBoxControl = formControls.AddComboBox(topLeftCell, 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