.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
A newer version of this page is available. Switch to the current version.

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

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

Property Value

Type Description
FormulaAutoCompleteSearchMode

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

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.

See Also