.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+

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

Declaration

[DefaultValue(FormulaAutoCompleteSearchMode.StartsWith)]
public FormulaAutoCompleteSearchMode SearchMode { get; set; }
<DefaultValue(FormulaAutoCompleteSearchMode.StartsWith)>
Public Property SearchMode As FormulaAutoCompleteSearchMode
[DefaultValue(FormulaAutoCompleteSearchMode.StartsWith)]
public FormulaAutoCompleteSearchMode SearchMode { get; set; }
<DefaultValue(FormulaAutoCompleteSearchMode.StartsWith)>
Public Property SearchMode As FormulaAutoCompleteSearchMode
[DefaultValue(FormulaAutoCompleteSearchMode.StartsWith)]
public FormulaAutoCompleteSearchMode SearchMode { get; set; }
<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.

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.

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.

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