Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

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

NuGet Package: DevExpress.Wpf.Spreadsheet

#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