Class XlsxFindOptions
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.
- 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.