Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

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.2.dll

NuGet Package: DevExpress.Wpf.Spreadsheet

#Declaration

public NameBoxItemDisplayMode FormulaBarNameBoxItemDisplayMode { get; set; }

#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:

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