Spread Windows Forms 6.0 Product Documentation
SearchDialog Property
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > FpSpread Class : SearchDialog Property


Glossary Item Box

Gets the dialog associated with searching for text in a cell of a sheet in this component.

Syntax

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 dialog

Remarks

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

Example

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

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

© 2002-2012 ComponentOne, a division of GrapeCity. All Rights Reserved.