# FarPoint.Win.Spread.FpSpread.Search

## Content

<div class="doc-site-dotnet-api-container">



<h1 id="FarPoint_Win_Spread_FpSpread_Search_" data-uid="FarPoint.Win.Spread.FpSpread.Search*">Search Method
</h1>
<div class="markdown level0 summary"></div>
<div class="markdown level0 conceptual"></div>



<a id="FarPoint_Win_Spread_FpSpread_Search_" data-uid="FarPoint.Win.Spread.FpSpread.Search*"></a>
<h4 id="FarPoint_Win_Spread_FpSpread_Search_System_Int32_System_String_System_Boolean_System_Boolean_System_Boolean_System_Boolean_System_Boolean_System_Boolean_System_Boolean_System_Int32_System_Int32_System_Int32__System_Int32__" data-uid="FarPoint.Win.Spread.FpSpread.Search(System.Int32,System.String,System.Boolean,System.Boolean,System.Boolean,System.Boolean,System.Boolean,System.Boolean,System.Boolean,System.Int32,System.Int32,System.Int32@,System.Int32@)">Search(int, string, bool, bool, bool, bool, bool, bool, bool, int, int, ref int, ref int)</h4>
<div class="markdown level1 summary"><p>Searches the text in the specified range of cells in the specified sheet<br>
for the specified string with the specified criteria.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">public string Search(int sheetIndex, string searchString, bool caseSensitive, bool exactMatch, bool alternateSearch, bool useWildcards, bool includeCellText, bool includeNotes, bool includeTags, int startRowIndex, int startColumnIndex, ref int foundRowIndex, ref int foundColumnIndex)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Public Function Search(sheetIndex As Integer, searchString As String, caseSensitive As Boolean, exactMatch As Boolean, alternateSearch As Boolean, useWildcards As Boolean, includeCellText As Boolean, includeNotes As Boolean, includeTags As Boolean, startRowIndex As Integer, startColumnIndex As Integer, ByRef foundRowIndex As Integer, ByRef foundColumnIndex As Integer) As String</code></pre>
</div>
<h5 class="parameters">Parameters</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Name</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">sheetIndex</span></td>
      <td><p>Sheet index on which to search</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.string">string</a></td>
      <td><span class="parametername">searchString</span></td>
      <td><p>String for which to search</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">caseSensitive</span></td>
      <td><p>Whether the search considers the case of the letters in the search string</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">exactMatch</span></td>
      <td><p>Whether the search considers only an exact match</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">alternateSearch</span></td>
      <td><p>Whether the search goes by alternate coordinates of column, row (instead of row, column)</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">useWildcards</span></td>
      <td><p>Whether the search considers wildcard characters (*, ?) in the search string</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">includeCellText</span></td>
      <td><p>Whether the search includes the content in the cell</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">includeNotes</span></td>
      <td><p>Whether the search includes the content in the cell notes</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">includeTags</span></td>
      <td><p>Whether the search includes the content in the cell tags or their string representations</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">startRowIndex</span></td>
      <td><p>Index of row at which to start</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">startColumnIndex</span></td>
      <td><p>Index of column at which to start</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">foundRowIndex</span></td>
      <td><p>Index of row at which match is found</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">foundColumnIndex</span></td>
      <td><p>Index of column at which match is found</p>
</td>
    </tr>
  </tbody>
</table>
<h5 class="returns">Returns</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.string">string</a></td>
      <td><p>The specified string with the specified criteria.</p>
</td>
    </tr>
  </tbody>
</table>


<a id="FarPoint_Win_Spread_FpSpread_Search_" data-uid="FarPoint.Win.Spread.FpSpread.Search*"></a>
<h4 id="FarPoint_Win_Spread_FpSpread_Search_System_Int32_System_String_System_Boolean_System_Boolean_System_Boolean_System_Boolean_System_Boolean_System_Boolean_System_Int32_System_Int32_System_Int32_System_Int32_System_Int32__System_Int32__" data-uid="FarPoint.Win.Spread.FpSpread.Search(System.Int32,System.String,System.Boolean,System.Boolean,System.Boolean,System.Boolean,System.Boolean,System.Boolean,System.Int32,System.Int32,System.Int32,System.Int32,System.Int32@,System.Int32@)">Search(int, string, bool, bool, bool, bool, bool, bool, int, int, int, int, ref int, ref int)</h4>
<div class="markdown level1 summary"><p>Searches the text in the specified range of cells in the specified sheet<br>
for the specified string with the specified criteria.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">public SearchFoundFlags Search(int sheetIndex, string searchString, bool caseSensitive, bool exactMatch, bool alternateSearch, bool useWildcards, bool includeNotes, bool includeTags, int startRowIndex, int startColumnIndex, int endRowIndex, int endColumnIndex, ref int foundRowIndex, ref int foundColumnIndex)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Public Function Search(sheetIndex As Integer, searchString As String, caseSensitive As Boolean, exactMatch As Boolean, alternateSearch As Boolean, useWildcards As Boolean, includeNotes As Boolean, includeTags As Boolean, startRowIndex As Integer, startColumnIndex As Integer, endRowIndex As Integer, endColumnIndex As Integer, ByRef foundRowIndex As Integer, ByRef foundColumnIndex As Integer) As SearchFoundFlags</code></pre>
</div>
<h5 class="parameters">Parameters</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Name</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">sheetIndex</span></td>
      <td><p>Sheet index on which to search</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.string">string</a></td>
      <td><span class="parametername">searchString</span></td>
      <td><p>String for which to search</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">caseSensitive</span></td>
      <td><p>Whether the search considers the case of the letters in the search string</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">exactMatch</span></td>
      <td><p>Whether the search considers only an exact match</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">alternateSearch</span></td>
      <td><p>Whether the search goes by alternate coordinates of column, row (instead of row, column)</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">useWildcards</span></td>
      <td><p>Whether the search considers wildcard characters (*, ?) in the search string</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">includeNotes</span></td>
      <td><p>Whether the search includes the content in the cell notes</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">includeTags</span></td>
      <td><p>Whether the search includes the content in the cell tags or their string representations</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">startRowIndex</span></td>
      <td><p>Row index at which to start</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">startColumnIndex</span></td>
      <td><p>Column index at which to start</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">endRowIndex</span></td>
      <td><p>Row index at which to end</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">endColumnIndex</span></td>
      <td><p>Column index at which to end</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">foundRowIndex</span></td>
      <td><p>Row index at which match is found</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">foundColumnIndex</span></td>
      <td><p>Column index at which match is found</p>
</td>
    </tr>
  </tbody>
</table>
<h5 class="returns">Returns</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="FarPoint.Win.Spread.SearchFoundFlags.html">SearchFoundFlags</a></td>
      <td><p>A <a class="xref" href="FarPoint.Win.Spread.SearchFoundFlags.html">SearchFoundFlags</a> value.</p>
</td>
    </tr>
  </tbody>
</table>


<a id="FarPoint_Win_Spread_FpSpread_Search_" data-uid="FarPoint.Win.Spread.FpSpread.Search*"></a>
<h4 id="FarPoint_Win_Spread_FpSpread_Search_System_Int32_System_String_System_Boolean_System_Boolean_System_Boolean_System_Boolean_System_Boolean_System_Boolean_System_Boolean_System_Boolean_System_Int32_System_Int32_System_Int32_System_Int32_System_Int32__System_Int32__" data-uid="FarPoint.Win.Spread.FpSpread.Search(System.Int32,System.String,System.Boolean,System.Boolean,System.Boolean,System.Boolean,System.Boolean,System.Boolean,System.Boolean,System.Boolean,System.Int32,System.Int32,System.Int32,System.Int32,System.Int32@,System.Int32@)">Search(int, string, bool, bool, bool, bool, bool, bool, bool, bool, int, int, int, int, ref int, ref int)</h4>
<div class="markdown level1 summary"><p>Searches the text in the specified range of cells in the specified sheet<br>
for the specified string with the specified criteria.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">public SearchFoundFlags Search(int sheetIndex, string searchString, bool caseSensitive, bool exactMatch, bool alternateSearch, bool useWildcards, bool includeCellText, bool includeNotes, bool includeTags, bool searchAsBlockRange, int startRowIndex, int startColumnIndex, int endRowIndex, int endColumnIndex, ref int foundRowIndex, ref int foundColumnIndex)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Public Function Search(sheetIndex As Integer, searchString As String, caseSensitive As Boolean, exactMatch As Boolean, alternateSearch As Boolean, useWildcards As Boolean, includeCellText As Boolean, includeNotes As Boolean, includeTags As Boolean, searchAsBlockRange As Boolean, startRowIndex As Integer, startColumnIndex As Integer, endRowIndex As Integer, endColumnIndex As Integer, ByRef foundRowIndex As Integer, ByRef foundColumnIndex As Integer) As SearchFoundFlags</code></pre>
</div>
<h5 class="parameters">Parameters</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Name</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">sheetIndex</span></td>
      <td><p>Sheet index on which to search</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.string">string</a></td>
      <td><span class="parametername">searchString</span></td>
      <td><p>String for which to search</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">caseSensitive</span></td>
      <td><p>Whether the search considers the case of the letters in the search string</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">exactMatch</span></td>
      <td><p>Whether the search considers only an exact match</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">alternateSearch</span></td>
      <td><p>Whether the search goes by alternate coordinates of column, row (instead of row, column)</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">useWildcards</span></td>
      <td><p>Whether the search considers wildcard characters (*, ?) in the search string</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">includeCellText</span></td>
      <td><p>Whether the search includes the content in the cell</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">includeNotes</span></td>
      <td><p>Whether the search includes the content in the cell notes</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">includeTags</span></td>
      <td><p>Whether the search includes the content in the cell tags or their string representations</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">searchAsBlockRange</span></td>
      <td><p>Specifies whether to search the specified block of cells only</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">startRowIndex</span></td>
      <td><p>Row Index at which to start</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">startColumnIndex</span></td>
      <td><p>Column index at which to start</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">endRowIndex</span></td>
      <td><p>Row Index at which to end</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">endColumnIndex</span></td>
      <td><p>Column index at which to end</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">foundRowIndex</span></td>
      <td><p>Row Index at which match is found</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">foundColumnIndex</span></td>
      <td><p>Column index at which match is found</p>
</td>
    </tr>
  </tbody>
</table>
<h5 class="returns">Returns</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="FarPoint.Win.Spread.SearchFoundFlags.html">SearchFoundFlags</a></td>
      <td><p>A <a class="xref" href="FarPoint.Win.Spread.SearchFoundFlags.html">SearchFoundFlags</a> value.</p>
</td>
    </tr>
  </tbody>
</table>


<a id="FarPoint_Win_Spread_FpSpread_Search_" data-uid="FarPoint.Win.Spread.FpSpread.Search*"></a>
<h4 id="FarPoint_Win_Spread_FpSpread_Search_System_Int32_System_Int32_System_String_System_Boolean_System_Boolean_System_Boolean_System_Boolean_System_Boolean_System_Boolean_System_Boolean_System_Int32_System_Int32_System_Int32_System_Int32_System_Int32__System_Int32__System_Int32__" data-uid="FarPoint.Win.Spread.FpSpread.Search(System.Int32,System.Int32,System.String,System.Boolean,System.Boolean,System.Boolean,System.Boolean,System.Boolean,System.Boolean,System.Boolean,System.Int32,System.Int32,System.Int32,System.Int32,System.Int32@,System.Int32@,System.Int32@)">Search(int, int, string, bool, bool, bool, bool, bool, bool, bool, int, int, int, int, ref int, ref int, ref int)</h4>
<div class="markdown level1 summary"><p>Searches the text in the specified range of cells in the specified sheet range
for the specified string with the specified criteria.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">public SearchFoundFlags Search(int startSheetIndex, int endSheetIndex, string searchString, bool caseSensitive, bool exactMatch, bool alternateSearch, bool useWildcards, bool includeCellText, bool includeNotes, bool includeTags, int startRowIndex, int startColumnIndex, int endRowIndex, int endColumnIndex, ref int foundSheetIndex, ref int foundRowIndex, ref int foundColumnIndex)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Public Function Search(startSheetIndex As Integer, endSheetIndex As Integer, searchString As String, caseSensitive As Boolean, exactMatch As Boolean, alternateSearch As Boolean, useWildcards As Boolean, includeCellText As Boolean, includeNotes As Boolean, includeTags As Boolean, startRowIndex As Integer, startColumnIndex As Integer, endRowIndex As Integer, endColumnIndex As Integer, ByRef foundSheetIndex As Integer, ByRef foundRowIndex As Integer, ByRef foundColumnIndex As Integer) As SearchFoundFlags</code></pre>
</div>
<h5 class="parameters">Parameters</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Name</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">startSheetIndex</span></td>
      <td><p>Sheet index on which to start the search</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">endSheetIndex</span></td>
      <td><p>Sheet index on which to end the search</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.string">string</a></td>
      <td><span class="parametername">searchString</span></td>
      <td><p>String for which to search</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">caseSensitive</span></td>
      <td><p>Whether the search considers the case of the letters in the search string</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">exactMatch</span></td>
      <td><p>Whether the search considers only an exact match</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">alternateSearch</span></td>
      <td><p>Whether the search goes by alternate coordinates of column, row (instead of row, column)</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">useWildcards</span></td>
      <td><p>Whether the search considers wildcard characters (*, ?) in the search string</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">includeCellText</span></td>
      <td><p>Whether the search includes the content in the cell</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">includeNotes</span></td>
      <td><p>Whether the search includes the content in the cell notes</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">includeTags</span></td>
      <td><p>Whether the search includes the content in the cell tags or their string representations</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">startRowIndex</span></td>
      <td><p>Row index at which to start</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">startColumnIndex</span></td>
      <td><p>Column index at which to start</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">endRowIndex</span></td>
      <td><p>Row index at which to end</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">endColumnIndex</span></td>
      <td><p>Column index at which to end</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">foundSheetIndex</span></td>
      <td><p>Sheet index at which the match is found</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">foundRowIndex</span></td>
      <td><p>Row index at which the match is found</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">foundColumnIndex</span></td>
      <td><p>Column index at which the match is found</p>
</td>
    </tr>
  </tbody>
</table>
<h5 class="returns">Returns</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="FarPoint.Win.Spread.SearchFoundFlags.html">SearchFoundFlags</a></td>
      <td><p>A <a class="xref" href="FarPoint.Win.Spread.SearchFoundFlags.html">SearchFoundFlags</a> value.</p>
</td>
    </tr>
  </tbody>
</table>


<a id="FarPoint_Win_Spread_FpSpread_Search_" data-uid="FarPoint.Win.Spread.FpSpread.Search*"></a>
<h4 id="FarPoint_Win_Spread_FpSpread_Search_System_Int32_System_String_System_Boolean_System_Boolean_System_Boolean_System_Boolean_System_Int32_System_Int32_System_Int32__System_Int32__" data-uid="FarPoint.Win.Spread.FpSpread.Search(System.Int32,System.String,System.Boolean,System.Boolean,System.Boolean,System.Boolean,System.Int32,System.Int32,System.Int32@,System.Int32@)">Search(int, string, bool, bool, bool, bool, int, int, ref int, ref int)</h4>
<div class="markdown level1 summary"><p>Searches the text in the cells in the specified sheet for the specified string with the specified criteria.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">public string Search(int sheetIndex, string searchString, bool caseSensitive, bool exactMatch, bool alternateSearch, bool useWildcards, int startRowIndex, int startColumnIndex, ref int foundRowIndex, ref int foundColumnIndex)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Public Function Search(sheetIndex As Integer, searchString As String, caseSensitive As Boolean, exactMatch As Boolean, alternateSearch As Boolean, useWildcards As Boolean, startRowIndex As Integer, startColumnIndex As Integer, ByRef foundRowIndex As Integer, ByRef foundColumnIndex As Integer) As String</code></pre>
</div>
<h5 class="parameters">Parameters</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Name</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">sheetIndex</span></td>
      <td><p>Index of sheet on which to search</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.string">string</a></td>
      <td><span class="parametername">searchString</span></td>
      <td><p>String for which to search</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">caseSensitive</span></td>
      <td><p>Whether the search considers the case of the letters in the search string</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">exactMatch</span></td>
      <td><p>Whether the search considers only an exact match</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">alternateSearch</span></td>
      <td><p>Whether the search goes by alternate coordinates of column, row (instead of row, column)</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">useWildcards</span></td>
      <td><p>Whether the search considers wildcard characters (*, ?) in the search string</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">startRowIndex</span></td>
      <td><p>Index of row at which to start</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">startColumnIndex</span></td>
      <td><p>Index of column at which to start</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">foundRowIndex</span></td>
      <td><p>Index of row at which match is found</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">foundColumnIndex</span></td>
      <td><p>Index of column at which match is found</p>
</td>
    </tr>
  </tbody>
</table>
<h5 class="returns">Returns</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.string">string</a></td>
      <td><p>A <a class="xref" href="FarPoint.Win.Spread.SearchFoundFlags.html">SearchFoundFlags</a> value.</p>
</td>
    </tr>
  </tbody>
</table>


<a id="FarPoint_Win_Spread_FpSpread_Search_" data-uid="FarPoint.Win.Spread.FpSpread.Search*"></a>
<h4 id="FarPoint_Win_Spread_FpSpread_Search_System_Int32_System_String_System_Boolean_System_Boolean_System_Boolean_System_Boolean_System_Int32_System_Int32_System_Int32_System_Int32_System_Int32__System_Int32__" data-uid="FarPoint.Win.Spread.FpSpread.Search(System.Int32,System.String,System.Boolean,System.Boolean,System.Boolean,System.Boolean,System.Int32,System.Int32,System.Int32,System.Int32,System.Int32@,System.Int32@)">Search(int, string, bool, bool, bool, bool, int, int, int, int, ref int, ref int)</h4>
<div class="markdown level1 summary"><p>Searches the text in the specified range of cells in the specified sheet<br>
for the specified string with the specified criteria.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">public string Search(int sheetIndex, string searchString, bool caseSensitive, bool exactMatch, bool alternateSearch, bool useWildcards, int startRowIndex, int startColumnIndex, int endRowIndex, int endColumnIndex, ref int foundRowIndex, ref int foundColumnIndex)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Public Function Search(sheetIndex As Integer, searchString As String, caseSensitive As Boolean, exactMatch As Boolean, alternateSearch As Boolean, useWildcards As Boolean, startRowIndex As Integer, startColumnIndex As Integer, endRowIndex As Integer, endColumnIndex As Integer, ByRef foundRowIndex As Integer, ByRef foundColumnIndex As Integer) As String</code></pre>
</div>
<h5 class="parameters">Parameters</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Name</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">sheetIndex</span></td>
      <td><p>Index of sheet on which to search</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.string">string</a></td>
      <td><span class="parametername">searchString</span></td>
      <td><p>String for which to search</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">caseSensitive</span></td>
      <td><p>Whether the search considers the case of the letters in the search string</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">exactMatch</span></td>
      <td><p>Whether the search considers only an exact match</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">alternateSearch</span></td>
      <td><p>Whether the search goes by alternate coordinates of column, row (instead of row, column)</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">useWildcards</span></td>
      <td><p>Whether the search considers wildcard characters (*, ?) in the search string</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">startRowIndex</span></td>
      <td><p>Index of row at which to start</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">startColumnIndex</span></td>
      <td><p>Index of column at which to start</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">endRowIndex</span></td>
      <td><p>Index of row at which to end</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">endColumnIndex</span></td>
      <td><p>Index of column at which to end</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">foundRowIndex</span></td>
      <td><p>Index of row at which match is found</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">foundColumnIndex</span></td>
      <td><p>Index of column at which match is found</p>
</td>
    </tr>
  </tbody>
</table>
<h5 class="returns">Returns</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.string">string</a></td>
      <td><p>A <a class="xref" href="FarPoint.Win.Spread.SearchFoundFlags.html">SearchFoundFlags</a> value.</p>
</td>
    </tr>
  </tbody>
</table>


<a id="FarPoint_Win_Spread_FpSpread_Search_" data-uid="FarPoint.Win.Spread.FpSpread.Search*"></a>
<h4 id="FarPoint_Win_Spread_FpSpread_Search_System_Int32_System_String_System_Boolean_System_Boolean_System_Boolean_System_Boolean_System_Boolean_System_Boolean_System_Boolean_System_Boolean_System_Int32_System_Int32_System_Int32_System_Int32_System_Boolean_System_Int32__System_Int32__" data-uid="FarPoint.Win.Spread.FpSpread.Search(System.Int32,System.String,System.Boolean,System.Boolean,System.Boolean,System.Boolean,System.Boolean,System.Boolean,System.Boolean,System.Boolean,System.Int32,System.Int32,System.Int32,System.Int32,System.Boolean,System.Int32@,System.Int32@)">Search(int, string, bool, bool, bool, bool, bool, bool, bool, bool, int, int, int, int, bool, ref int, ref int)</h4>
<div class="markdown level1 summary"><p>Searches the text in the cells in the specified sheet for the specified string with the specified criteria
and the location to start and end, and whether to search notes and tags as well.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">public SearchFoundFlags Search(int sheetIndex, string searchString, bool caseSensitive, bool exactMatch, bool alternateSearch, bool useWildcards, bool includeCellText, bool includeNotes, bool includeTags, bool reverseSearching, int startRowIndex, int startColumnIndex, int endRowIndex, int endColumnIndex, bool searchAsBlockRange, ref int foundRowIndex, ref int foundColumnIndex)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Public Function Search(sheetIndex As Integer, searchString As String, caseSensitive As Boolean, exactMatch As Boolean, alternateSearch As Boolean, useWildcards As Boolean, includeCellText As Boolean, includeNotes As Boolean, includeTags As Boolean, reverseSearching As Boolean, startRowIndex As Integer, startColumnIndex As Integer, endRowIndex As Integer, endColumnIndex As Integer, searchAsBlockRange As Boolean, ByRef foundRowIndex As Integer, ByRef foundColumnIndex As Integer) As SearchFoundFlags</code></pre>
</div>
<h5 class="parameters">Parameters</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Name</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">sheetIndex</span></td>
      <td><p>Index of sheet on which to search</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.string">string</a></td>
      <td><span class="parametername">searchString</span></td>
      <td><p>String for which to search</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">caseSensitive</span></td>
      <td><p>Whether the search considers the case of the letters in the search string</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">exactMatch</span></td>
      <td><p>Whether the search considers only an exact match</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">alternateSearch</span></td>
      <td><p>Whether the search goes by alternate coordinates of column, row (instead of row, column)</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">useWildcards</span></td>
      <td><p>Whether the search considers wildcard characters (*, ?) in the search string</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">includeCellText</span></td>
      <td><p>Whether the search includes the content in the cell</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">includeNotes</span></td>
      <td><p>Whether the search includes the content in the cell notes</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">includeTags</span></td>
      <td><p>Whether the search includes the content in the cell tags or their string representations</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">reverseSearching</span></td>
      <td><p>Whether the search is in reversed order</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">startRowIndex</span></td>
      <td><p>Index of row at which to start</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">startColumnIndex</span></td>
      <td><p>Index of column at which to start</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">endRowIndex</span></td>
      <td><p>Index of row at which to end</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">endColumnIndex</span></td>
      <td><p>Index of column at which to end</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">searchAsBlockRange</span></td>
      <td><p>Specifies whether to search the specified block of cells only</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">foundRowIndex</span></td>
      <td><p>Index of row at which match is found</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">foundColumnIndex</span></td>
      <td><p>Index of column at which match is found</p>
</td>
    </tr>
  </tbody>
</table>
<h5 class="returns">Returns</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="FarPoint.Win.Spread.SearchFoundFlags.html">SearchFoundFlags</a></td>
      <td><p>A <a class="xref" href="FarPoint.Win.Spread.SearchFoundFlags.html">SearchFoundFlags</a> value.</p>
</td>
    </tr>
  </tbody>
</table>
</div>