API Reference
Class
ExcelFormulaSearchOptions
Controls reference-aware formula search.
Inheritance
- Object
- ExcelFormulaSearchOptions
Usage
This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.
Accepted by parameters
- Method ExcelDocument.SearchFormulas
- Method ExcelSheet.SearchFormulas
Constructors
public ExcelFormulaSearchOptions() #Inherited Methods
public override Boolean Equals(Object obj) #Returns:
BooleanInherited from Object
Parameters
- obj Object
Properties
public String Text { get; set; } #Optional formula text fragment, excluding or including a leading equals sign.
public String Reference { get; set; } #Optional A1 cell/range reference. Intersecting formula references are matched.
public String Function { get; set; } #Optional function name such as SUM or XLOOKUP.
public Boolean MatchCase { get; set; } #Whether text and function matching is case-sensitive.
public Int32 MaximumResults { get; set; } #Maximum returned formula cells.