.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
Row

SearchOptions.SearchIn Property

Specifies whether to search cell values only or extend search to include underlying formulas.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v21.1.Core.dll

Declaration

public SearchIn SearchIn { get; set; }

Property Value

Type Description
SearchIn

One of the SearchIn enumeration values indicating what to examine in each cell.

Remarks

For more information about how to perform a search in the document, see Find and Replace.

Example

The example below demonstrates how to perform a search with the specified options in the active worksheet and highlight all matching cells.

workbook.LoadDocument("Documents\ExpenseReport.xlsx")
workbook.Calculate()
Dim worksheet As Worksheet = workbook.Worksheets(0)

' Specify the search term.
Dim searchString As String = Date.Today.ToString("d")

' Specify search options.
Dim options As New SearchOptions()
options.SearchBy = SearchBy.Columns
options.SearchIn = SearchIn.Values
options.MatchEntireCellContents = True

' Find all cells containing today's date and paint them light-green.
Dim searchResult As IEnumerable(Of Cell) = worksheet.Search(searchString, options)
For Each cell As Cell In searchResult
    cell.Fill.BackgroundColor = Color.LightGreen
Next cell
See Also