F4 key binding

F4 key binding

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

• 

  davide.vago

  • Post Options:
  • Link
    Copy

  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

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 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

• 

  davide.vago

  • Post Options:
  • Link
    Copy

  Posted 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

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 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