Spread for ASP.NET 9.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
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 a search flag.
// 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());
}
'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 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

See Also

Reference

FarPoint.Web.Spread Namespace
FpSpread Search Methods

 

 


Copyright © GrapeCity, inc. All rights reserved.