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


In This Topic
    Search Method
    In This Topic
    Searches the text in the specified range of cells in the specified sheet for the specified string with the specified criteria.
    Searches the text in the cells of a sheet in the Spread component for the specified string.
    Overload List
    OverloadDescription
    Search(Int32,String,Boolean,Boolean,Boolean,Boolean,Boolean,Boolean,Boolean,Int32,Int32,Int32,Int32) Searches the text in the specified range of cells in the specified sheet for the specified string with the specified criteria.  
    Search(Int32,String,Boolean,Boolean,Boolean,Boolean,Boolean,Boolean,Int32,Int32,Int32,Int32,Int32,Int32) Searches the text in the specified range of cells in the specified sheet for the specified string with the specified criteria.  
    Search(Int32,String,Boolean,Boolean,Boolean,Boolean,Boolean,Boolean,Boolean,Boolean,Int32,Int32,Int32,Int32,Int32,Int32) Searches the text in the specified range of cells in the specified sheet for the specified string with the specified criteria.  
    Search(Int32,Int32,String,Boolean,Boolean,Boolean,Boolean,Boolean,Boolean,Boolean,Int32,Int32,Int32,Int32,Int32,Int32,Int32) Searches the text in the specified range of cells in the specified sheet range for the specified string with the specified criteria.  
    Search(Int32,String,Boolean,Boolean,Boolean,Boolean,Int32,Int32,Int32,Int32) Searches the text in the cells in the specified sheet for the specified string with the specified criteria.  
    Search(Int32,String,Boolean,Boolean,Boolean,Boolean,Int32,Int32,Int32,Int32,Int32,Int32) Searches the text in the specified range of cells in the specified sheet for the specified string with the specified criteria.  
    Search(Int32,String,Boolean,Boolean,Boolean,Boolean,Boolean,Boolean,Boolean,Boolean,Int32,Int32,Int32,Int32,Boolean,Int32,Int32) 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.  
    Remarks

    These search methods search 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.

    These search methods check the formatted string, that is the Text in the cell, not the Value.

    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
    SearchWithDialog Method
    SearchDialog Property
    SearchFoundFlags Enum

    User-Task Documentation

    Customizing User Searching of Data

     

     

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

    Product Support Forum | Print this page