Visual Basic (Declaration) | |
---|---|
Public ReadOnly Property SearchDialog As SearchDialog |
Visual Basic (Usage) | Copy Code |
---|---|
Dim instance As FpSpread Dim value As SearchDialog value = instance.SearchDialog |
C# | |
---|---|
public SearchDialog SearchDialog {get;} |
Property Value
SearchDialog object containing the seach dialogThe search has these qualifications:
- This method only searches the cells in the data area, not the headers.
- This method only checks against the formatted string -- the Text in the cell, not the Value.
- This method only searches the specified cells in one sheet.
- All the cells that contain data that can be represented as a string by the Text property of that cell are searched and that includes hidden and locked cells.
- Cell notes and cell tags are not part of the search.
This property is available at run time only.
This example sets up the search dialog.
C# | Copy Code |
---|---|
fpSpread1.SearchWithDialog(""); fpSpread1.SearchDialog.AlternateSearch = true; fpSpread1.SearchDialog.CaseSensitive = false; fpSpread1.SearchDialog.ExactMatch = false; fpSpread1.SearchDialog.SearchString = "155"; fpSpread1.SearchDialog.SheetIndex = 0; fpSpread1.SearchDialog.StartColumnIndex = 0; fpSpread1.SearchDialog.StartRowIndex = 0; fpSpread1.SearchDialog.UseWildcards = false; |
Visual Basic | Copy Code |
---|---|
FpSpread1.SearchWithDialog("") FpSpread1.SearchDialog.AlternateSearch = True FpSpread1.SearchDialog.CaseSensitive = False FpSpread1.SearchDialog.ExactMatch = False FpSpread1.SearchDialog.SearchString = "155" FpSpread1.SearchDialog.SheetIndex = 0 FpSpread1.SearchDialog.StartColumnIndex = 0 FpSpread1.SearchDialog.StartRowIndex = 0 FpSpread1.SearchDialog.UseWildcards = False |
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
Reference
FpSpread ClassFpSpread Members
Search Method
SearchWithDialog Method