How to load combobox inside a cell in WinForms Spreadsheet (SfSpreadsheet)?

1 min read

Load combobox inside a cell

You can load ComboBox cell in SfSpreadsheet by applying the List Validation to the cell like below code example.

string[] data = { "A", "B", "C" };
var range = Spreadsheet.ActiveSheet.Range["D5:D10"].DataValidation;
range.ListOfValues = data;
Spreadsheet.ActiveGrid.InvalidateCell(GridRangeInfo.Cells(5,4,10,5));

Samples:

WPF

WinForms

UWP

Reference link: https://help.syncfusion.com/windowsforms/spreadsheet/editing#data-validation

Did you find this information helpful?

Yes

Comments (0)

How to load combobox inside a cell in WinForms Spreadsheet (SfSpreadsheet)?

Load combobox inside a cell

Access denied