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

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

  • 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?
  • Replied 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
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels