GrapeCity.Documents.Excel.FindLookIn

FindLookIn Enum

Specifies the type of data to search in when using Find(object, IRange, FindOptions).

Used with LookIn to control where the find operation searches: formulas, displayed text, raw values, or comments.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public enum FindLookIn

Public Enum FindLookIn

Examples

worksheet.Range["A1"].Value = "Hello";
worksheet.Range["A2"].Formula = "=A1";
worksheet.Range["A3"].AddComment("review this");

IRange searchRange = worksheet.Range["A1:A3"];
FindOptions options = new FindOptions();
options.LookIn = FindLookIn.Formulas;
IRange found = searchRange.Find("A1", null, options);

Fields

Name	Description
Comments	Searches in comments.
Formulas	Searches in formulas.
OnlyFormulas	Searches in formulas. If the HasFormula property of a cell is false, the cell will be skipped.
Texts	Searches in texts.
TextsExcludeFormulaCell	Searches in Texts. If the HasFormula property of a cell is true, the cell will be skipped.
Values	Performs type sensitive search in values. Supports double, string (Wildcard match is disabled), DateTime, bool, TimeSpan, and CalcError. Non-double number value matches its double equivalent.