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

    See Also

    Reference

    FpSpread Class
    FpSpread Members

    User-Task Documentation

    Setting Up a Search Dialog

     

     

    Copyright © 2003-2020 GrapeCity, Inc. All rights reserved.

    Product Support Forum | Print this page