F4 to set absolute references

F4 to set absolute references

Posted by: jeff on 19 April 2020, 5:44 pm EST

• 

  jeff

  • Post Options:
  • Link
    Copy

  Posted 19 April 2020, 5:44 pm EST

  Do you the F4 key to switch between 1) absolute, 2)absolute row, absolute col 4) relative reference types in a cell. See the Excel docs for the F4 keys behavior.

  https://support.office.com/en-us/article/Switch-between-relative-absolute-and-mixed-references-DFEC08CD-AE65-4F56-839E-5F0D8D0BACA9

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 20 April 2020, 1:36 am EST

  Hi Jeff,

  You may add the following shortcut to add the required functionality:

  spread
      .commandManager()
      .setShortcutKey("changeFormulaReference", 115, false, false, false, false); //115 is key code for F4
  

  You may also refer to the following sample demonstrating the same:
  
  https://codesandbox.io/s/spread-js-starter-13pkv

  Regards
  
  Sharad