Crtl+Down/Up/Right/Left/Right do not stop at cells with data

Crtl+Down/Up/Right/Left/Right do not stop at cells with data

Posted by: mwyatt on 8 June 2021, 5:49 am EST

• 

  mwyatt

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 8 June 2021, 5:49 am EST

  In Excel if I use the Ctrl+Down / Ctrl+Up / Ctrl+Left / Ctrl+Right it will focus on the next cell in the direction used that contains data. In SpreadJS it jumps to the last cell available in the table in the given direction.

  Example:
  
  Data is in cell L5. Focus is on L1 and pressed Ctrl+Down. In Excel, the focus stops at cell L5. In SpreadJS it jumps to the last row available cell L200

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 8 June 2021, 6:24 pm EST

  Hi,

  For this you need to create a custom command on these keys, please refer to the following sample that demonstrates how we could achieve the required functionality.

  sample: https://stackblitz.com/edit/js-phhf96?file=KeyCommands.js

  Regards,
  
  Avinash