Table of Contents

Class XlsxFindOptions

Namespace
DocWright.Formats.Xlsx
Assembly
DocWright.Formats.Xlsx.dll

How a search of a workbook matches.

public sealed class XlsxFindOptions
Inheritance
XlsxFindOptions
Inherited Members

Remarks

The same options a search of a document takes (DocWright.Dom.Editing.FindOptions), with the same defaults, and three a grid adds: WholeCell, SearchIn and CellFilter.

Constructors

XlsxFindOptions()

Creates options with the defaults.

Properties

CellFilter

Gets or sets which cells are searched, or null for all: Excel's Find with a format, or with any other condition. A cell is searched only when this returns true for it.

MatchCase

Gets or sets a value indicating whether the search is case-sensitive. Default true. Case-insensitive matching is ordinal, never culture-sensitive: a workbook is not searched differently because the machine running the search is Turkish.

MaxMatches

Gets or sets the maximum number of matches to return or to replace, or 0 for no limit. Default 0.

RegexTimeout

Gets or sets the maximum time one regular-expression match attempt may take. Default one second. A caller-supplied pattern is an unbounded-backtracking surface, so this is enforced, not advisory.

SearchIn

Gets or sets what is searched in a cell that holds a formula. Default Values.

WholeCell

Gets or sets a value indicating whether a match must be the whole of the cell's text, as Excel's "Match entire cell contents". Default false.

WholeWord

Gets or sets a value indicating whether a match must be bounded by non-word characters on both sides. Default false.