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.v24.1.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
Declaration
[DefaultValue(FormulaAutoCompleteSearchMode.StartsWith)]
public FormulaAutoCompleteSearchMode SearchMode { get; set; }
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. |
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. |
Property Paths
You can access this nested property as listed below:
Object Type | Path to SearchMode |
---|---|
SpreadsheetControlOptions |
|
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.