We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

cobo Box creation in spread sheet control.

Thread ID:

Created:

Updated:

Platform:

Replies:

110835 Aug 27,2013 07:49 AM Aug 29,2013 10:09 PM WPF 1
loading
Tags: SpreadsheetControl(Classic)
MANI SHANKAR
Asked On August 27, 2013 07:49 AM

StringCollection

list = new StringCollection();

list.Add("One");

list.Add("Two");

list.Add("Three");

var

combo1 = SpreadIOList.GridProperties.ActiveSpreadsheetGrid.CurrentCell.Grid.Model[1, 1];

combo1.CellType =

"ComboBox";

combo1.ChoiceList = list;

combo1.DropDownStyle = Syncfusion.Windows.Controls.Grid.

GridDropDownStyle.Editable;

// 

 

prob statment:

 i am getting exception in xamalparseexception.

for any help thanks in advance.

 

 

   

 

 

 


Pannir Selvam S [Syncfusion]
Replied On August 29, 2013 10:09 PM

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


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;