F2 F3 F4 how to prevent spread overtook these function keys

Posted by: wwu-sec on 8 September 2017, 12:37 pm EST

  • Posted 8 September 2017, 12:37 pm EST

    in my harsh project, F2 F3 F4 already defined in outside container, but when spread cell get focus, these function keys are routed to spread specific function, i don't need that, please teach me, it is very busy project, thanks a lot!!
  • Replied 8 September 2017, 12:37 pm EST


    You would need to cancel the action of the keys in the InputMap of Spread.

     <pre class="coloredcode"> <span class="kwd">Dim</span> im <span class="kwd">As</span> FarPoint.Win.Spread.InputMap
    im = FpSpread1.GetInputMap(Spread.InputMapMode.WhenAncestorOfFocused)
    im.Put(<span class="kwd">New</span> FarPoint.Win.Spread.Keystroke(Keys.F2, Keys.None), FarPoint.Win.Spread.SpreadActions.None)
  • Replied 8 September 2017, 12:37 pm EST

    Dear BobM,

    my F2 handler is a customized function, that will be fine? i mean when hit F2 in spread cell, it should invoke that customized F2 handler.

    thanks a lot.
  • Replied 8 September 2017, 12:37 pm EST

    What is it you want to happen when you hit the F2 key?
  • Replied 8 September 2017, 12:37 pm EST

    'disable Function key in farpoint spread, because function key already defined in FORM

    Dim im As FarPoint.Win.Spread.InputMap

    im = grid_upper.GetInputMap(FarPoint.Win.Spread.InputMapMode.WhenAncestorOfFocused)

    im.Put(New FarPoint.Win.Spread.Keystroke(Keys.F4, Keys.None), FarPoint.Win.Spread.SpreadActions.None)

    im = grid_bottom.GetInputMap(FarPoint.Win.Spread.InputMapMode.WhenAncestorOfFocused)

    im.Put(New FarPoint.Win.Spread.Keystroke(Keys.F4, Keys.None), FarPoint.Win.Spread.SpreadActions.None)


    it works! thanks a lot!!!
Need extra support?

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

Learn More

Forum Channels