Context Menu in React Spreadsheet

14 Aug 20264 minutes to read

The Context menu is used to improve user interaction with the Spreadsheet through a popup menu. It opens when right-clicking on a cell, column header, row header, or pager in the Spreadsheet. You can use the enableContextMenu property to enable or disable the context menu.

The default value for the enableContextMenu property is true.

Context Menu Items in Row Cell

The following table lists the default context menu items and their actions.

Context Menu items Action
Cut Cuts the data from the selected cells to the clipboard. Select a target cell to move the data.
Copy Copies the data from the selected cells to the clipboard so it can be pasted elsewhere.
Paste Pastes the clipboard contents into the spreadsheet.
Paste Special Values - Paste the data values from clipboard to spreadsheet. Formats - Paste the data formats from
clipboard to spreadsheet.
Filter Filters the selected cells based on the value of the active cell.
Sort Sorts the selected range of cells in ascending or descending order.
Hyperlink Create a link in the spreadsheet to navigate to web links or cell reference within the sheet or other sheets
in the Spreadsheet.

Context Menu Items in Row Header / Column Header

The context menu in row and column headers provides quick access to common actions for managing spreadsheet data.
Refer to the table below for the default context menu items and their actions.

Context Menu items Action
Cut Cuts the data from the selected row/column header to the clipboard. Select a target cell to move the data.
Copy Copies the data from the selected row/column header to the clipboard so it can be pasted elsewhere.
Paste Pastes the clipboard contents into the spreadsheet.
Paste Special Values - Paste the data values from clipboard to spreadsheet. Formats - Paste the data formats from
clipboard to spreadsheet.
Insert Rows / Insert Columns Inserts new rows or columns into the worksheet.
Delete Rows / Delete Columns Deletes the selected rows or columns from the worksheet.
Hide Rows / Hide Columns Hides the selected rows or columns.
UnHide Rows / UnHide Columns Shows the hidden rows or columns.

Context Menu Items in Pager

The context menu in the pager provides quick access to actions for managing worksheet navigation and related options.
The following table lists the default items and their actions.

Context Menu items Action
Insert Insert a new worksheet in front of an existing worksheet in the spreadsheet.
Delete Delete the selected worksheet from the spreadsheet.
Rename Rename the selected worksheet.
Protect Sheet Prevent unwanted changes from others by limiting their ability to edit.
Hide Hide the selected worksheet.

Note

You can refer to our React Spreadsheet Editor feature tour page for its groundbreaking feature representations.

See Also