Combo Cell Type - other way to see drop down

Posted by: sagar-fp on 8 September 2017, 12:30 pm EST

  • Posted 8 September 2017, 12:30 pm EST

    Hi, 

    I need to show the drop down box of the combo cell type when the user presses the Shift + Down arrow key combination.

    Is there any way to do this?

    Thanks.


  • Replied 8 September 2017, 12:30 pm EST

    Hello,


    You can map the KeyDown event of the combo control and programatically drop down the list on a ShiftDown keystroke.

     
    	Private Sub FpSpread1_EditModeOn(ByVal sender As Object, ByVal e As System.EventArgs) Handles FpSpread1.EditModeOn
    Dim c As FarPoint.Win.FpCombo
    If FpSpread1.ActiveSheet.ActiveColumnIndex = 1 Then
    c = CType(FpSpread1.EditingControl, FarPoint.Win.FpCombo)
    AddHandler c.KeyDown, AddressOf comboKD
    End If
    End Sub

    Public Sub
    comboKD(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs)
    Dim c As FarPoint.Win.FpCombo = CType(sender, FarPoint.Win.FpCombo)
    If e.KeyCode = Keys.Down And e.Shift Then
    c.DroppedDown = True
    End If
    End Sub
     
  • Replied 8 September 2017, 12:30 pm EST

    Or you could add the Shift DownArrow key combo into your InputMap and specify the ShowSubEditor action.
Need extra support?

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

Learn More

Forum Channels