officefileapi-devexpress-dot-xtraspreadsheet-dot-spreadsheetformulaautocompleteoptions-49949cc0.md
Gets or sets a value that specifies what items should appear in the Formula AutoComplete drop-down list.
Namespace : DevExpress.XtraSpreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
[DefaultValue(FormulaAutoCompleteSearchMode.StartsWith)]
public FormulaAutoCompleteSearchMode SearchMode { get; set; }
<DefaultValue(FormulaAutoCompleteSearchMode.StartsWith)>
Public Property SearchMode As FormulaAutoCompleteSearchMode
| Type | Default | Description |
|---|---|---|
| FormulaAutoCompleteSearchMode | StartsWith |
One of the FormulaAutoCompleteSearchMode 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.
| | Contains |
Specifies that the Formula AutoComplete list should display all items that contain the text typed into a cell.
|
You can access this nested property as listed below:
| Object Type | Path to SearchMode |
|---|---|
| SpreadsheetControlOptions |
.FormulaAutoComplete .SearchMode
|
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
SpreadsheetFormulaAutoCompleteOptions Class