Hi Mani Shankar,
Thanks for contacting Syncfusion support.
We have analyzed your query and we have tried to meet your
requirement by setting the ComboBox celltype to the Cell in the QueryCellInfo
event of grid like below code snippet.
Code Snippet[C#]:
var grid = this.spreadSheetControl.GridProperties.ActiveSpreadsheetGrid; grid.Model.QueryCellInfo += new GridQueryCellInfoEventHandler(Model_QueryCellInfo);
void Model_QueryCellInfo(object sender, GridQueryCellInfoEventArgs e)
{
if (e.Style.RowIndex == 0 || e.Style.ColumnIndex == 0)
return;
if (e.Style.ColumnIndex == 1)
{
e.Style.CellType = "ComboBox";
e.Style.ItemsSource = new List<string>(){"One","Two","Three"};
}
}
|
We have prepared a sample based on this and you can download
the sample from the below location.
Sample: SpreadsheetDemo_WPF
(2).zip
Please let us know if you have any other queries.
Thanks,
Pannir