Spread Windows Forms 9.0 Product Documentation
Search Method


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.

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

See Also

Reference

FpSpread Class
FpSpread Members
SearchWithDialog Method
SearchDialog Property
SearchFoundFlags Enum

User-Task Documentation

Customizing User Searching of Data

 

 


Copyright © GrapeCity, inc. All rights reserved.