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.v20.1.dll

Declaration

public NameBoxItemDisplayMode FormulaBarNameBoxItemDisplayMode { get; set; }
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.

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