Change the enter direction from row to column in Spreadsheet

[Eric Huang]

Hi Team,

I would like to change the enter direction from row to column in Spreadsheet, like this option in Excel. can I do it? Thanks.

Best Regards,
Eric

[Vasanth Ravi]

Hi Eric,

Currently, we don’t have support what you mean. However, your requirement can be achieved through keyDownHandler() event. We have prepared a sample that prompts you to navigate through cells on right. We have fetched the address on the near by cell to the active cell and make it to navigate.

Please find the code block and sample for your kind reference.

CODE BLOCK:

 

<ejs-spreadsheet ref="spreadsheet" :created="created" @keydown="onCellSave()">

 

onCellSave(){

      var spreadsheet = this.$refs.spreadsheet.ej2Instances;

        if (event.keyCode === 13) {

            event.stopImmediatePropagation();

            spreadsheet.endEdit();

            var sheet = spreadsheet.getActiveSheet();

            let cellIdx = getRangeIndexes(sheet.activeCell);

            var nextCell = getRangeAddress([ cellIdx[0], cellIdx[1] + 1, cellIdx[2], cellIdx[3] + 1]);

            spreadsheet.selectRange(nextCell);

        }

    },

 

Sample Link: https://www.syncfusion.com/downloads/support/directtrac/general/ze/Vue_KeyDown-1665651792

Get back to us if you need further assistance regarding.

Note: If this post is helpful, please mark it as an answer so that other members can locate it more quickly.

[Eric Huang]

Hi Vasanth,

The sample code works and perfect. Thanks for help!

[Sangeetha Priya Murugan]

You are welcome, Eric. We are glad that your requirement has been fulfilled.

Note: If that post is helpful, please consider Accepting it as the solution so that other members can locate it more quickly.