Editable ComboCellType losing it's value after a copy

Posted by: loy-chan on 8 September 2017, 1:23 pm EST

  • Posted 8 September 2017, 1:23 pm EST


    I'm experiencing a wierd problem. If I have a combocelltype using the following code and if I select an item, copy the selected item text, then click another cell, the selected item in the combobox disappears.


    List<string> lstNames = new List<string>();

    List<string> lstIds = new List<string>();







    ComboBoxCellType cmbType = new ComboBoxCellType();

    cmbType.AutoCompleteMode = AutoCompleteMode.Append;

    cmbType.AutoCompleteSource = AutoCompleteSource.ListItems;

    cmbType.Editable = true;

    cmbType.EditorValue = EditorValue.ItemData;

    cmbType.Items = lstNames.ToArray();

    cmbType.ItemData = lstIds.ToArray();

    fpSpread1.Sheets[1].Cells[0, 0].CellType = cmbType;



    After some trial and error, I found that the combination of the highlighted lines are the source of the problem.



  • Replied 8 September 2017, 1:23 pm EST

    I was able to reproduce this and have written it up as a bug to be fixed in the next maintenance release.
  • Replied 8 September 2017, 1:23 pm EST

    Dear BobM, 


    I am Anand from chennai, Recently i faced this problem and i need a solution for this. if Possible plz update..


  • Replied 8 September 2017, 1:23 pm EST


    I was not able to replicate the issue at my end with the latest build of Spread i.e Spread.Net6 v6.0.xx06. I would suggest you to test the issue with the same to see if it resolves the issue that you are currently facing. You may download the same from the following link:

    Hope it will help you. Please let me know if you have any queries further.


    Manpreet Kaur

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels