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 WinForms Spreadsheet 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: DataValidation in Windows Forms Spreadsheet

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