Combobox celltype not opening dropdown on clck

Posted by: himandri.negi on 14 September 2020, 5:15 pm EST

  • Posted 14 September 2020, 5:15 pm EST

    created a celltype as combobox in windows form when i am clicking on the drop butto nothing happens but when i i keep clicking i can see the dropdown for a sec and it never opens.

    please help and let me what am i doing wrong
  • Marked as Answer

    Replied 15 September 2020, 6:40 pm EST


    Without looking at your code, I cannot predict the exact source of the problem for you, but I can share how you should be creating a Combobox CellType in your Spread Win application.

    Add Combobox Cell Type:
    FarPoint.Win.Spread.CellType.ComboBoxCellType cmbct = new FarPoint.Win.Spread.CellType.ComboBoxCellType();
    cmbct.Items = (new String[] { "Item 1", "Item 2", "Item 3", "Item 4", "Item 5", "Item 6" });
    fpSpread1.Sheets[0].Cells[1, 1].CellType = cmbct;
    The above code is enough to add a combobox in an application with no custom code.

    Properties that can alter the behavior of Combobox's dropdown button: To be able to observe proper behavior, when clicking the dropdown button, please ensure that the following properties are defined as follows:
    cmbct.DoubleClickTextToDropDown = false;
    cmbct.DropDownOptions = FarPoint.Win.DropDownOptions.ButtonAndText;
    fpSpread1.ButtonDrawMode = ButtonDrawModes.Always;
    fpSpread1.ActiveSheet.OperationMode = OperationMode.Normal;
    Additionally, I have attached a sample program for your reference. If the above suggestions don't help, you can modify the program and share back for us to investigate.

Need extra support?

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

Learn More

Forum Channels