FindOptions
Configuration for find operations specifying search criteria, scope, direction, and matching rules.
Definition
Namespace:Telerik.Windows.Documents.Spreadsheet.Model
Assembly:Telerik.Windows.Documents.Spreadsheet.dll
Syntax:
public class FindOptionsInheritance: objectFindOptions
Derived Classes:
Constructors
Initializes find options with default settings: search by rows within the current sheet in formula content.
public FindOptions()Properties
Direction for traversing cells, either row-by-row or column-by-column.
public FindBy FindBy { get; set; }The find by option.
Cell content type to search within: raw formula text or formatted display values.
public FindInContentType FindIn { get; set; }The find in option.
Text pattern to search for; supports wildcards (* and ?) unless escaped.
public string FindWhat { get; set; }The searched string.
Scope controlling whether to search only the current sheet or across the entire workbook.
public FindWithin FindWithin { get; set; }The find within option.
Whether to perform case-sensitive matching; when false, comparisons ignore case.
public bool MatchCase { get; set; }The value indicating whether the match case option should be used.
Whether to match only when the search pattern equals the entire cell content, not just a substring.
public bool MatchEntireCellContents { get; set; }The value indicating whether the option to match entire cell contents should be used.
SearchRanges
IEnumerable<CellRange>
Optional collection of cell ranges to limit the search scope; if null, searches the entire configured scope.
public IEnumerable<CellRange> SearchRanges { get; set; }The search ranges.
Cell position where the search begins; subsequent searches wrap around if no match is found.
public WorksheetCellIndex StartCell { get; set; }The start cell.
Methods
Copies all search configuration properties from another FindOptions instance into this one.