SearchFoundFlags Enumeration

Visual Basic
C#

'Declaration
 
Public Enum SearchFoundFlags 
   Inherits System.Enum

'Usage
 
Dim instance As SearchFoundFlags

public enum SearchFoundFlags : System.Enum

Member	Description
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

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:

3 if found in cell text and cell note (1+2)
5 if found in cell text and cell tag (1+4)
6 if found in cell note and cell tag (2+4)
7 if found in all three places (1+2+4)

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

This example returns the row and column of the found text if it is in a cell.

C#

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)
}

Visual Basic

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

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

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

Reference

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

User-Task Documentation

Customizing User Searching of Data