SpreadsheetFormulaAutoCompleteOptions.SearchMode Property

Gets or sets a value that specifies what items should appear in the Formula AutoComplete drop-down list. This is a dependency property.

Namespace: DevExpress.Xpf.Spreadsheet

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

NuGet Package: DevExpress.Wpf.Spreadsheet

Declaration

C#

public SpreadsheetFormulaAutoCompleteSearchMode SearchMode { get; set; }

VB.NET

Public Property SearchMode As SpreadsheetFormulaAutoCompleteSearchMode

Property Value

Type	Description
SpreadsheetFormulaAutoCompleteSearchMode	One of the SpreadsheetFormulaAutoCompleteSearchMode enumeration members that specifies the mode for displaying matching items in the Formula AutoComplete list.

Available values:

Name	Description
StartsWith	Specifies that the Formula AutoComplete list should display all items that start with the text typed into a cell.
Contains	Specifies that the Formula AutoComplete list should display all items that contain the text typed into a cell.

Property Paths

You can access this nested property as listed below:

Object Type	Path to SearchMode
SpreadsheetControlOptions	.FormulaAutoComplete .SearchMode

Remarks

Use the SearchMode property to control the displaying of matching items in the Formula AutoComplete drop-down list. This property is set to SpreadsheetFormulaAutoCompleteSearchMode.StartsWith by default, so all items that start with the characters entered into a cell appear in the Formula AutoComplete list. If SearchMode is SpreadsheetFormulaAutoCompleteSearchMode.Contains, the Formula AutoComplete list includes all items containing specified characters.