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

Declaration

public SpreadsheetFormulaAutoCompleteSearchMode SearchMode { get; set; }

Property Value

Type Description
SpreadsheetFormulaAutoCompleteSearchMode

One of the SpreadsheetFormulaAutoCompleteSearchMode 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.

DXSpreadsheet_FormulaAutoComplete_StartsWith

Contains

Specifies that the Formula AutoComplete list should display all items that contain the text typed into a cell.

DXSpreadsheet_FormulaAutoComplete_Contains

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 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