Category / Section
How to load ComboBox inside a cell in Spreadsheet?
1 min read
You can load ComboBox cell in SfSpreadsheet by applying the List Validation to the cell like below code example.
C#
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));
To Know more about Data Validation, please refer the below UG link:
https://help.syncfusion.com/wpf/sfspreadsheet/editing#data-validation
Sample link:
