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 |
---|---|
Spreadsheet |
One of the Spreadsheet |
Available values:
Name | Description |
---|---|
Starts |
Specifies that the Formula Auto |
Contains | Specifies that the Formula Auto |
#Property Paths
You can access this nested property as listed below:
Object Type | Path to Search |
---|---|
Spreadsheet |
|
#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.