Spread Windows Forms 10.0 Product Documentation
SearchFoundFlags Enumeration
Example Example 


Specifies where the search string is found.
Syntax
'Declaration
 
Public Enum SearchFoundFlags 
   Inherits System.Enum
'Usage
 
Dim instance As SearchFoundFlags
public enum SearchFoundFlags : System.Enum 
Members
MemberDescription
CellNote[2] Indicates that the string is found in the cell note
CellTag[4] Indicates that the string is found in the cell tag
CellText[1] Indicates that the string is found in the cell text
Error[0] Indicates an error has occured due to an invalid argument
Remarks

When using the search methods for searching a cell in the data area, the value may be single member, such as "CellText", or it may be a number if the found string is in more than one. Possible numeric values are:

When using the search methods for searching a cell in the headers, the value is typically a single member.

Example
This example returns the row and column of the found text if it is in a cell.
int rowindx = 0;
int colindx = 0;
int sheetindx = 0

FarPoint.Win.Spread.SearchFoundFlags sff;

sff = fpSpread1.Search(0, 0, "Davolio",false, false, false, true, true, false, false, 0, 0, 10, 5, ref sheetindx, ref rowindx,
ref colindx);

if (sff = FarPoint.Win.Spread.SearchFoundFlags.CellText)
{
MessageBox.Show("The text was found in cell " & rowindx & " - " & colindx)
}
Dim rowindx As Integer
Dim colindx As Integer
Dim sheetindx As Integer

Dim sff As FarPoint.Win.Spread.SearchFoundFlags

sff = FpSpread1.Search(0, 0, "Davolio", False, False, False, True, True, False, False, 0, 0, 10, 5, sheetindx, rowindx, colindx)

If sff = FarPoint.Win.Spread.SearchFoundFlags.CellText Then
MessageBox.Show("The text was found in cell " & rowindx & " - " & colindx)
End If
Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         FarPoint.Win.Spread.SearchFoundFlags

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

FarPoint.Win.Spread Namespace
Search Methods (FpSpread Class)

User-Task Documentation

Customizing User Searching of Data

 

 


Copyright © GrapeCity, inc. All rights reserved.