Keyboard cursor navigation isn't matching Excel behaviour

Keyboard cursor navigation isn't matching Excel behaviour

Posted by: davide.vago on 4 December 2020, 1:59 pm EST

• 

  davide.vago

  • Post Options:
  • Link
    Copy

  Posted 4 December 2020, 1:59 pm EST - Updated 3 October 2022, 10:04 am EST

  Hi there,

  I’m currently facing navigation inconsistencies with the keyboard prebuilt events.

  1. Ctrl+arrow up or arrow down should normally go to the next filled cell up or down but it appears to go right to the top or bottom of the page.

  2. Ctrl + Shift + arrow up(or arrow down) and Ctrl + Shift + arrow left (or arrow right) should normally be able to select all the cells as far as the next filled cell (up, down, left or right respectively)

  In the example below in excel I was in cell A14,
  
  I then pressed Ctrl-arrow up and I ended up in cell A6.

  This is the result we’d like from SpreadJS spreadsheets but it does seems a bit different (you can check in any example from your demos page: https://www.grapecity.com/spreadjs/demos/showcase/financialkpis/purejs)

  

  454×854 84 KB

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 8 December 2020, 8:35 am EST

  Hi Davide,

  We are able to observe the issue hence we have made an enhancement request for the required functionality. We will update you regarding this as soon as we get any information. The internal ID for this issue will be SJS-6803. Till then you may create your custom commands. Please refer to the attached sample for demonstrates and let us know if you face any issues.

  sample: https://codesandbox.io/s/nostalgic-sound-5reue?file=/src/index.js

  Regards
  
  Avinash