SpreadsheetControl.FormulaBarNameBoxItemDisplayMode Property

Gets or sets a value indicating what items should appear in the Name Box list of the integrated formula bar. This is a dependency property.

Namespace: DevExpress.Xpf.Spreadsheet

Assembly: DevExpress.Xpf.Spreadsheet.v24.1.dll

NuGet Package: DevExpress.Wpf.Spreadsheet

Declaration

C#

public NameBoxItemDisplayMode FormulaBarNameBoxItemDisplayMode { get; set; }

VB.NET

Public Property FormulaBarNameBoxItemDisplayMode As NameBoxItemDisplayMode

Property Value

Type	Description
NameBoxItemDisplayMode	A NameBoxItemDisplayMode enumeration member specifying what items should be displayed in the Name Box‘s drop-down list.

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 of the integrated formula bar:

XAML

<dxsps:SpreadsheetControl x:Name="spreadsheetControl" ShowFormulaBar="True" FormulaBarNameBoxItemDisplayMode="ExcludeDefinedNames, ExcludeTableNames"/>