Back to Devexpress

SearchOptions.MatchEntireCellContents Property

officefileapi-devexpress-dot-spreadsheet-dot-searchoptions-2effc1fe.md

latest4.9 KB
Original Source

SearchOptions.MatchEntireCellContents Property

Gets or sets a value indicating whether or not to search for cells whose contents are exactly alike.

Namespace : DevExpress.Spreadsheet

Assembly : DevExpress.Spreadsheet.v25.2.Core.dll

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

csharp
public bool MatchEntireCellContents { get; set; }
vb
Public Property MatchEntireCellContents As Boolean

Property Value

TypeDescription
Boolean

true , to restrict the search to the entire cell content; otherwise, false.

|

Remarks

Set the MatchEntireCellContents property to true to search for an exact match of characters specified by the search term. For example, searching for “Order” matches the cell values “Order” or “order” (if capitalization is not taken into account), but not “Orders” or “Order Details” or other values containing the specific text anywhere inside the cell.

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

The following code snippets (auto-collected from DevExpress Examples) contain references to the MatchEntireCellContents property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

winforms-spreadsheetcontrol-api-part-2/CS/SpreadsheetControl_API_Part02/SpreadsheetActions/SearchActions.cs#L46

csharp
options.SearchIn = SearchIn.Values;
options.MatchEntireCellContents = true;

wpf-spreadsheetcontrol-api-part-2/CS/SpreadsheetControl_WPF_API_Part02/SpreadsheetActions/SearchActions.cs#L48

csharp
options.SearchIn = SearchIn.Values;
options.MatchEntireCellContents = true;

spreadsheet-document-api-examples-part2/CS/SpreadsheetDocServerAPIPart2/CodeExamples/SearchActions.cs#L41

csharp
options.SearchIn = SearchIn.Values;
options.MatchEntireCellContents = true;

winforms-spreadsheetcontrol-api-part-2/VB/SpreadsheetControl_API_Part02/SpreadsheetActions/SearchActions.vb#L43

vb
options.SearchIn = SearchIn.Values
options.MatchEntireCellContents = True

wpf-spreadsheetcontrol-api-part-2/VB/SpreadsheetControl_WPF_API_Part02/SpreadsheetActions/SearchActions.vb#L45

vb
options.SearchIn = SearchIn.Values
options.MatchEntireCellContents = True

spreadsheet-document-api-examples-part2/VB/SpreadsheetDocServerAPIPart2/CodeExamples/SearchActions.vb#L38

vb
options.SearchIn = SearchIn.Values
options.MatchEntireCellContents = True

See Also

Range.Search*

Worksheet.Search*

IWorkbook.Search*

SearchOptions Class

SearchOptions Members

DevExpress.Spreadsheet Namespace