SpreadsheetNameBoxControl.ItemDisplayMode Property

Gets or sets a value indicating what items should appear in the Name Box list.

Namespace : DevExpress.XtraSpreadsheet

Assembly : DevExpress.XtraSpreadsheet.v25.2.dll

NuGet Package : DevExpress.Win.Spreadsheet

Declaration

C#
VB.NET

csharp

[DefaultValue(NameBoxItemDisplayMode.Default)]
[DXCategory("Behavior")]
public NameBoxItemDisplayMode ItemDisplayMode { get; set; }

<DXCategory("Behavior")>
<DefaultValue(NameBoxItemDisplayMode.Default)>
Public Property ItemDisplayMode As NameBoxItemDisplayMode

Property Value

Type	Default	Description
NameBoxItemDisplayMode	Default

A NameBoxItemDisplayMode enumeration member specifying what items should be displayed in the drop-down list of the Name Box control.

Available values:

Name	Description
Default

Specifies that all items should be displayed in the Name Box.

| | ExcludeTableNames |

Specifies that table names should not be displayed in the Name Box.

| | ExcludeDefinedNames |

Specifies that defined names should not be displayed in the Name Box.

Remarks

The following code snippet shows how to exclude both the defined names and table names from the Name Box :

C#
VB.NET

csharp

using DevExpress.XtraSpreadsheet;
// ... 
spreadsheetNameBoxControl1.ItemDisplayMode = NameBoxItemDisplayMode.ExcludeDefinedNames | NameBoxItemDisplayMode.ExcludeTableNames;

Imports DevExpress.XtraSpreadsheet
' ... 
spreadsheetNameBoxControl1.ItemDisplayMode = NameBoxItemDisplayMode.ExcludeDefinedNames Or NameBoxItemDisplayMode.ExcludeTableNames