SearchWithDialogAdvanced Method

Searches the text in the cells of the sheets for the search string with the default criteria using a provided advanced search dialog.

Searches the text in the cells of the Spread component for the search string with input from a dialog with additional options.

Overload List

Overload	Description
SearchWithDialogAdvanced(String)	Searches the text in the cells of the sheets for the search string with the default criteria using a provided advanced search dialog.
SearchWithDialogAdvanced(Int32,Int32,String,Boolean,Boolean,Boolean,Boolean,Int32,Int32)	Searches the text in the cells of the specified sheet range for the specified string with the specified criteria using a provided advanced search dialog.

Remarks

These search methods have these qualifications:

Searches all the cells that contain data that can be represented as a string by the Text property of that cell, and that includes hidden and locked cells
Only checks the formatted string, that is the Text in the cell, not the Value
Only searches the cells in the data area, not the headers
Only searches the specified cells in one sheet
Cell notes and cell tags are not searched

For a hierarchy of sheets, these methods only search cells in a parent sheet. To search child sheets, you would need to perform a separate search of each child sheet.

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

FpSpread Class
FpSpread Members

User-Task Documentation

Setting Up a Search Dialog