F4 key binding

Posted by: davide.vago on 17 March 2020, 8:15 pm EST

  • Posted 17 March 2020, 8:15 pm EST

    Good morning/afternoon

    I'm currently implementing a bunch of shortcuts on my spread instances to cope with the standard excel user experience.

    One of these binding I'm trying to do is the F4:

    F4: Repeat your last action. If you have a cell reference or range selected when you hit F4, Excel cycles through available references.

    Do you have any suggestion on how to achieve it?
    I'm currently following the pattern you guys gave me long time ago, using the commandManager.

    Looking forward to hear from you
  • Replied 18 March 2020, 9:39 pm EST

    Hi Davide,

    We have asked the dev team to confirm if this is something that is possible using the current API(Internal tracking ID: SJS-3889). We will update you as soon as we get an update from the team.

    Regards
    Sharad
  • Replied 7 April 2020, 11:43 pm EST

    Hi Sharad,

    I was wondering you have had some feedback on this request.

    Looking forward to hearing from you
    Regards,
    Davide
  • Replied 8 April 2020, 4:30 pm EST

    Hi Davide,

    For changing the type of cell reference "changeFormulaReference" command could be used. We only need to add the following shortcut:
    spread
    .commandManager()
    .setShortcutKey("changeFormulaReference", 115, false, false, false, false);

    Regarding repeating the last action, it is still with the dev team, I've asked the team for an update, will let you know as soon as I get the update.

    Regards
    Sharad
Need extra support?

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

Learn More

Forum Channels