Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / FpSpread Class / SearchWithDialogAdvanced Method


In This Topic
    SearchWithDialogAdvanced Method
    In This Topic
    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
    OverloadDescription
    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 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.

    See Also