How to get relevant cell on contextMenuItemSelect event

[Majid Razmjoo]

I want to get the exact cell (reference including the address, not just the value) the onContextMenuItemSelect event only pass the menu item and not the cell on which the context menu was opened. I was looking for a context menu item click event but I didn't find any. Is there a way to get a reference of the cell when a context menu is opened?

 Here is a codesandbox.

[Sangeetha Priya Murugan]

Hi Majid,

Your requirement can be achievable by using the getActiveSheet method, activeCell and selectedRange property. The activeCell property returns the current sheet active cell and selectedRange property returns the range of selected cells in active sheet as shown below.

Code Block:

 

 

 function contextMenuItemSelect(args) {

    let sheet = spreadsheet.getActiveSheet();

    console.log(sheet.activeCell); // active cell

    console.log(sheet.selectedRange); // returns the selected range

  }

 

 

For your convenience we have prepared the sample based on our suggestion. Please find the link below.

Sample Link: https://stackblitz.com/edit/react-mcbnsq?file=index.js

[Majid Razmjoo]

Thank you. This is exactly what I needed.

[Sangeetha Priya Murugan]

Hi Majid,

We are happy to hear that your issue has been resolved. Kindly get back to us if you need any further assistance.

Regards,

Sangeetha M