Combo box Cell type Issue

Posted by: kunal-mi-17 on 8 September 2017, 12:31 pm EST

  • Posted 8 September 2017, 12:31 pm EST

    <P>I am using spread 2.5 version for Win Forms, There is a combo box cell type in the spread which gets populated during run time, now when a user press ctrl- x in the combo box, the selected text is not getting cleared, </P>
    <P>I cannot make the cell editable, is there any way by which ctrl- x should work without making the cell editable. </P>
    <P>It was working for me in the com version of spread that is 3.0 version..Please suggest.</P>
    <P>-Kunal </P>
  • Replied 8 September 2017, 12:31 pm EST

    You could set value to -1 to get rid of the selection (nothing is selected). <br>
  • Replied 8 September 2017, 12:31 pm EST

    <P><FONT face=Arial size=2>It would be great if you could give me some code snippet and also the details of where the code should be put.</FONT></P>
    <P><FONT face=Arial size=2>- Kunal</FONT></P>
  • Replied 8 September 2017, 12:31 pm EST

    Kunal -<br><br>You can set up an inputmap for the key combination.  The code can go in the Form_Load event...<br><br>Dim im As FarPoint.Win.Spread.InputMap<br>im = FpSpread1.GetInputMap(FarPoint.Win.Spread.InputMapMode.WhenAncestorOfFocused)<br>im.Put(New FarPoint.Win.Spread.Keystroke(Keys.X, Keys.Control), FarPoint.Win.Spread.SpreadActions.ClearCell)<br>
Need extra support?

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

Learn More

Forum Channels