New to Telerik Document ProcessingStart a free 30-day trial

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:

C#
public class FindOptions

Inheritance: objectFindOptions

Derived Classes: ReplaceOptions

Constructors

Initializes find options with default settings: search by rows within the current sheet in formula content.

C#
public FindOptions()

Methods

Copies all search configuration properties from another FindOptions instance into this one.

C#
public void CopyPropertiesFrom(FindOptions options)
Parameters:optionsFindOptions

The options.

Determines whether the specified object is equal to the current object.

C#
public override bool Equals(object obj)
Parameters:objobject

The object to compare with the current object.

Returns:

bool

True if the specified object is equal to the current object; otherwise, false.

Overrides: object.Equals(object)

Serves as a hash function for a particular type.

C#
public override int GetHashCode()
Returns:

int

A hash code for the current object.

Overrides: object.GetHashCode()

Properties

Direction for traversing cells, either row-by-row or column-by-column.

C#
public FindBy FindBy { get; set; }
Property Value:

The find by option.

Cell content type to search within: raw formula text or formatted display values.

C#
public FindInContentType FindIn { get; set; }
Property Value:

The find in option.

Text pattern to search for; supports wildcards (* and ?) unless escaped.

C#
public string FindWhat { get; set; }
Property Value:

The searched string.

Scope controlling whether to search only the current sheet or across the entire workbook.

C#
public FindWithin FindWithin { get; set; }
Property Value:

The find within option.

Whether to perform case-sensitive matching; when false, comparisons ignore case.

C#
public bool MatchCase { get; set; }
Property Value:

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.

C#
public bool MatchEntireCellContents { get; set; }
Property Value:

The value indicating whether the option to match entire cell contents should be used.

Optional collection of cell ranges to limit the search scope; if null, searches the entire configured scope.

C#
public IEnumerable<CellRange> SearchRanges { get; set; }
Property Value:

The search ranges.

Cell position where the search begins; subsequent searches wrap around if no match is found.

C#
public WorksheetCellIndex StartCell { get; set; }
Property Value:

The start cell.