SpreadsheetFormulaAutoCompleteOptions.SearchMode Property

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

Namespace: DevExpress.XtraSpreadsheet

Assembly: DevExpress.Spreadsheet.v19.1.Core.dll

Declaration

C#

[DefaultValue(FormulaAutoCompleteSearchMode.StartsWith)]
public FormulaAutoCompleteSearchMode SearchMode { get; set; }

VB.NET

<DefaultValue(FormulaAutoCompleteSearchMode.StartsWith)>
Public Property SearchMode As FormulaAutoCompleteSearchMode

Property Value

Type	Default	Description
FormulaAutoCompleteSearchMode	**StartsWith**	One of the FormulaAutoCompleteSearchMode 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 FormulaAutoCompleteSearchMode.StartsWith by default, so all items that start with the characters entered into a cell appear in the Formula AutoComplete list. If SearchMode is FormulaAutoCompleteSearchMode.Contains, the Formula AutoComplete list includes all items containing specified characters.