Skip to main content

Search OfficeIMO

Enter a topic, API type, or PowerShell command.

Documentation Search all OfficeIMO/
Class

ExcelFormulaSearchOptions

OfficeIMO.Excel

Namespace
OfficeIMO.Excel
Assembly
OfficeIMO.Excel
Source revision
e163ccb36643 with working tree changes
Modifiers
sealed

Controls reference-aware formula search.

Inheritance

  • object
  • ExcelFormulaSearchOptions

Usage

Explore 2 API references to this type

This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.

Accepted by parameters 2

Constructors

public ExcelFormulaSearchOptions() #

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 bool MatchCase { get; set; } #

Whether text and function matching is case-sensitive.

public int MaximumResults { get; set; } #

Maximum returned formula cells.