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

NuGet Package: DevExpress.Spreadsheet.Core

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.