SpreadsheetMenuType Enum

Lists values used to specify the type of the SpreadsheetControl’s context menu.

Namespace: DevExpress.XtraSpreadsheet

Assembly: DevExpress.XtraSpreadsheet.v18.1.dll

Declaration

C#

public enum SpreadsheetMenuType

VB.NET

Public Enum SpreadsheetMenuType

Members

Name	Description
None	Specifies no menu.
ColumnHeading	Specifies a context menu which can be invoked by right-clicking a column header.
RowHeading	Specifies a context menu which can be invoked by right-clicking a row header.
SelectAllButton	Specifies a context menu which can be invoked by right-clicking the Select All button in the upper-left corner of a worksheet.
SheetTab	Specifies a context menu which can be invoked by right-clicking a worksheet tab.
Picture	Specifies a context menu which can be invoked by right-clicking a picture embedded in a worksheet.
Chart	Specifies a context menu which can be invoked by right-clicking a chart in a worksheet.
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.
Cell	Specifies a context menu which can be invoked by right-clicking any cell in a worksheet.
AutoFilter	Specifies a context menu which can be invoked by clicking the AutoFilter drop-down arrow.
PivotTable	Specifies a context menu which can be invoked by right-clicking any cell in a pivot table.
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.

Related API Members

The following properties accept/return SpreadsheetMenuType values:

• PopupMenuShowingEventArgs.MenuType

Remarks

The SpreadsheetMenuType enumeration values are used by the PopupMenuShowingEventArgs.MenuType property.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the SpreadsheetMenuType enum.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

how-to-customize-the-spreadsheet-context-menu-e4978/CS/SpreadsheetContextMenu/Form1.cs#L29

{
    if (e.MenuType == SpreadsheetMenuType.Cell)
    {

VB.NET

how-to-customize-the-spreadsheet-context-menu-e4978/VB/SpreadsheetContextMenu/Form1.vb#L27

Private Sub spreadsheetControl1_PopupMenuShowing(ByVal sender As Object, ByVal e As PopupMenuShowingEventArgs) Handles spreadsheetControl1.PopupMenuShowing
    If e.MenuType = SpreadsheetMenuType.Cell Then
        ' Remove the "Clear Contents" menu item.