Skip to main content

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 SpreadsheetMenuTypeAutoFilter Specifies a context menu which can be invoked by clicking the AutoFilter drop-down arrow.
SpreadsheetMenuType.Cell SpreadsheetMenuTypeCell Specifies a context menu which can be invoked by right-clicking any cell in a worksheet.
SpreadsheetMenuType.Chart SpreadsheetMenuTypeChart Specifies a context menu which can be invoked by right-clicking a chart in a worksheet.
SpreadsheetMenuType.ColumnHeading SpreadsheetMenuTypeColumnHeading Specifies a context menu which can be invoked by right-clicking a column header.
SpreadsheetMenuType.DrawingObjects SpreadsheetMenuTypeDrawingObjects 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 SpreadsheetMenuTypePicture Specifies a context menu which can be invoked by right-clicking a picture embedded in a worksheet.
SpreadsheetMenuType.PivotTable SpreadsheetMenuTypePivotTable Specifies a context menu which can be invoked by right-clicking any cell in a pivot table.
SpreadsheetMenuType.PivotTableAutoFilter SpreadsheetMenuTypePivotTableAutoFilter 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 SpreadsheetMenuTypeRowHeading Specifies a context menu which can be invoked by right-clicking a row header.
SpreadsheetMenuType.SelectAllButton SpreadsheetMenuTypeSelectAllButton 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 SpreadsheetMenuTypeSheetTab 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.