Back to Devexpress

SpreadsheetControl.FormulaBarNameBoxItemDisplayMode Property

wpf-devexpress-dot-xpf-dot-spreadsheet-dot-spreadsheetcontrol-fb0e3713.md

latest2.5 KB
Original Source

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

NuGet Package : DevExpress.Wpf.Spreadsheet

Declaration

csharp
public NameBoxItemDisplayMode FormulaBarNameBoxItemDisplayMode { get; set; }
vb
Public Property FormulaBarNameBoxItemDisplayMode As NameBoxItemDisplayMode

Property Value

TypeDescription
NameBoxItemDisplayMode

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

|

Available values:

NameDescription
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"/>

See Also

Create a Simple Spreadsheet Application

SpreadsheetControl Class

SpreadsheetControl Members

DevExpress.Xpf.Spreadsheet Namespace