FormControlCollection.AddListBox(CellRange) Method
In This Article
Creates a list box form control at the specified cell range.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v24.2.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
#Declaration
ListBoxFormControl AddListBox(
CellRange targetRange
)
#Parameters
Name | Type | Description |
---|---|---|
target |
Cell |
The cell range where the form control should be located. |
#Returns
Type | Description |
---|---|
List |
The list box form control. |
#Remarks
#Example
The code sample below creates a list box control:
using DevExpress.Spreadsheet;
Workbook workbook = new Workbook();
workbook.LoadDocument("Document.xlsx");
var cellRange = workbook.Worksheets[0].Range["B2:D2"];
var listBoxControl = formControls.AddListBox(cellRange);
listBoxControl.SourceRange = workbook.Worksheets[0].Range["E2:E6"];
listBoxControl.SelectedIndex = 1;
Note
The Form
method call adds a new item to both Form
See Also