Spreadsheet Context Menus
- 2 minutes to read
The WPF Spreadsheet supports several types of context menus. These menus are invoked when a user clicks anywhere on a worksheet (for example, a cell, row or column header, picture or chart).
The following table lists the available context menu types:
Menu Type | Appearance | Description |
---|---|---|
SpreadsheetMenuType.AutoFilter | Specifies a context menu which can be invoked by clicking the AutoFilter drop-down arrow. | |
SpreadsheetMenuType.Cell | Specifies a context menu which can be invoked by right-clicking any cell in a worksheet. | |
SpreadsheetMenuType.Chart | Specifies a context menu which can be invoked by right-clicking a chart in a worksheet. | |
SpreadsheetMenuType.ColumnHeading | Specifies a context menu which can be invoked by right-clicking a column header. | |
SpreadsheetMenuType.DrawingObjects | Specifies a context menu which can be invoked by right-clicking a drawing object when a worksheet contains several drawing objects, such as pictures or charts. | |
SpreadsheetMenuType.Picture | Specifies a context menu which can be invoked by right-clicking a picture embedded in a worksheet. | |
SpreadsheetMenuType.PivotTable | Specifies a context menu which can be invoked by right-clicking any cell in a pivot table. | |
SpreadsheetMenuType.PivotTableAutoFilter | Specifies a context menu which can be invoked by clicking the AutoFilter drop-down arrow on the row or column label of a pivot table. | |
SpreadsheetMenuType.RowHeading | Specifies a context menu which can be invoked by right-clicking a row header. | |
SpreadsheetMenuType.SelectAllButton | Specifies a context menu which can be invoked by right-clicking the Select All button in the upper-left corner of a worksheet. | |
SpreadsheetMenuType.SheetTab | Specifies a context menu which can be invoked by right-clicking a worksheet tab. |
Customize Context Menus
Use the SpreadsheetControl.MenuCustomizations property or handle the SpreadsheetControl.PopupMenuShowing event to customize the Spreadsheet control’s context menus. You can add, modify or remove menu items. See the following help topic for more information: Customize the Spreadsheet Context Menus.