Pop-up Dialog not appearing when using keyboard shortcuts

Pop-up Dialog not appearing when using keyboard shortcuts

Posted by: mwyatt on 30 September 2021, 4:15 pm EST

• 

  mwyatt

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 30 September 2021, 4:15 pm EST

  I am using the latest 14.2 SpreadJS and am running into three separate scenarios where in Excel using a keyboard shortcut a pop-up would appear where the user would select row or column to continue.
  
  Those scenarios are as follows:

  • Ctrl + Shift + “+” to insert a row (I can insert a row or column if the entire row or column is highlighted but can’t if only a single cell has focus)
  • Alt + Shift + Right Arrow to group columns or rows
  • CTRL + ‘-’ to remove a row or column (I can remove a row or column if the entire row or column is highlighted but can’t if only a single cell has focus)

  Does SpreadJS support any pop-up dialogs etc?

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 1 October 2021, 3:07 am EST

  Hi,

  For this, you need to create custom commands and register those commands on desired key combinations. Please refer to the following sample that demonstrates how you could implement the first shortcut(Ctrl + Shift + “+”) in SJS.

  sample: https://codesandbox.io/s/spread-js-starter-forked-51o4q?file=/src/index.js

  Custom Actions demo: https://www.grapecity.com/spreadjs/demos/features/worksheet/actions/custom-action#demo_source_name

  register method: https://www.grapecity.com/spreadjs/docs/v14/online/SpreadJS~GC.Spread.Commands.CommandManager~register.html

  Regards
  
  Avinash