After using Back to delete a cell, need to press Enter

After using Back to delete a cell, need to press Enter

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

• 

  mwyatt

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 8 June 2021, 5:09 am EST

  After deleting a cell using BackSpace key, I need to press the Enter key before I can use the arrows to navigate around. In Excel, I can Press BackSpace and then navigate using arrow keys.

  Can this be fixed to match Excel?

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 8 June 2021, 10:43 pm EST

  Hi,

  For this, you may create a custom command. Please refer to the following code snippet and let us know if you face any issues.

  
    let commandManger = spread.commandManager();
    commandManger.register(
      "editwithNavigate",
      {
        isUndo: false,
        execute: function (spread) {
          let sheet = spread.getActiveSheet();
          if (!sheet.isEditing()) {
            sheet.setValue(
              sheet.getActiveRowIndex(),
              sheet.getActiveColumnIndex(),
              null
            );
            sheet.startEdit();
          }
        }
      },
      8,
      false,
      false,
      false
    );
  
  

  custome Action Demo: https://www.grapecity.com/spreadjs/demos/features/worksheet/actions/sheet-actions/purejs
  
  Regards
  
  Avinash