Angular Spreadsheet Context Menu
The Spreadsheet context menu provides extensive capabilities identical to what Microsoft Excel has to offer. For example, you can copy and paste content from the clipboard directly into cells, or you can fine-tune the visibility of rows and columns.
The available options in the context menu vary depending on your current selection.
The following example demonstrates the Spreadsheet context menu in action. Right-click a cell, a column header, or row header to see the available options.
Context Menu Items in Cell
The following table lists the context menu items that are available, regardless of your current cell, row, or column selection.
| Option | Description |
|---|---|
| Copy | Copies the selected cells or content to the clipboard. |
| Cut | Cuts the selected cells or content to the clipboard. |
| Paste | Pastes the clipboard contents into the selected cells. |
| Merge all | Merges the selected cells into a single cell. |
| Merge vertically | Merges the selected cells vertically. |
| Merge horizontally | Merges the selected cells horizontally. |
| Insert link | Inserts a hyperlink into selected cells. |
Context Menu Items in Row Header and Column Header
The following Spreadsheet context menu items are available for entire rows and columns (in addition to the context menu items for the cells). To view the row- and column-specific items, right-click the respective row or column header.
| Column-only | Description |
|---|---|
| Add column left | Adds a column to the left of the selected columns. |
| Add column right | Adds a column to the right of the selected columns. |
| Delete column | Deletes the selected columns. |
| Hide column | Hides the selected columns from view. |
| Unhide column | Shows the previously hidden column. |
| Row-only option | Description |
|---|---|
| Add row above | Adds a row above the selected rows. |
| Add row below | Adds a row below the selected rows. |
| Delete row | Deletes the selected rows. |
| Hide row | Hides the selected rows from view. |
| Unhide row | Shows the previously hidden rows. |