Spread for ASP.NET 7.0 Product Documentation
SearchFoundFlags Enumeration
Example  See Also  Support Options
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace : SearchFoundFlags Enumeration


Glossary Item Box

Specifies where the search string is found.

Syntax

Visual Basic (Declaration) 
Public Enum SearchFoundFlags 
   Inherits System.Enum
Visual Basic (Usage)Copy Code
Dim instance As SearchFoundFlags
C# 
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

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:

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

Example

This example returns a search flag.
C#Copy Code
// Page Load
FpSpread1.Sheets.Count = 2;
FpSpread1.Sheets[0].Cells[1, 1].Tag = "test";
private void Button1_Click(object sender, System.EventArgs e)
{ 
int x = 0;
int y = 0;
int z =0;
FarPoint.Web.Spread.SearchFoundFlags sff;
sff = FpSpread1.Search(0, 1, "test", false, false, false, false, false, false, true, 0, 0, 2, 2, ref z, ref x, ref y);
ListBox1.Items.Add(sff.ToString());
ListBox1.Items.Add(x.ToString());
ListBox1.Items.Add(y.ToString());
ListBox1.Items.Add(z.ToString());
}
Visual BasicCopy Code
'Page Load 
FpSpread1.Sheets.Count = 2
FpSpread1.Sheets(0).Cells(1, 1).Tag = "test"

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim x As Integer
Dim y As Integer
Dim z As Integer
Dim sff As FarPoint.Web.Spread.SearchFoundFlags
sff = FpSpread1.Search(0, 1, "test", False, False, False, False, False, False, True, 0, 0, 2, 2, z, x, y)
ListBox1.Items.Add(sff.ToString())
ListBox1.Items.Add(x)
ListBox1.Items.Add(y)
ListBox1.Items.Add(z)
End Sub

Inheritance Hierarchy

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

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

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