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.v20.1.dll

Declaration

public SpreadsheetFormulaAutoCompleteSearchMode SearchMode { get; set; }
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.

Property Paths

You can access this nested property as listed below:

Object Type Path to SearchMode
SpreadsheetControl
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.

See Also