GrapeCity.Xaml.SpreadSheet.Data
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
CellFormula [8] Indicates that the string is found in the cell formula.
CellTag [4] Indicates that the string is found in the cell tag.
CellText [1] Indicates that the string is found in the cell text.
None [0] Indicates that no string is found.
Example
This example uses the SearchFoundFlags enumeration.
gcSpreadSheet1.Sheets[0].Cells[5, 4].Text = "test";                      

private void Button_Click_1(object sender, RoutedEventArgs e)
        {
int colfound;
int rowfound;
int sheetfound;
string foundstring;
colfound = 0;
rowfound = 0;
sheetfound = 0;
gcSpreadSheet1.SheetCount = 2;
//gcSpreadSheet1.Search(0, "test", out rowfound, out colfound);
//gcSpreadSheet1.Search(0, "test", GrapeCity.Xaml.SpreadSheet.Data.SearchFlags.ExactMatch, out rowfound, out colfound);
//gcSpreadSheet1.Search(0, "test", GrapeCity.Xaml.SpreadSheet.Data.SearchFlags.ExactMatch, GrapeCity.Xaml.SpreadSheet.Data.SearchOrder.ZOrder, out rowfound, out colfound);
//gcSpreadSheet1.Search(0, "test", GrapeCity.Xaml.SpreadSheet.Data.SearchFlags.ExactMatch, GrapeCity.Xaml.SpreadSheet.Data.SearchOrder.ZOrder, GrapeCity.Xaml.SpreadSheet.Data.SearchFoundFlags.CellText, out rowfound, out colfound);
//gcSpreadSheet1.Search(0, "test", GrapeCity.Xaml.SpreadSheet.Data.SearchFlags.ExactMatch, GrapeCity.Xaml.SpreadSheet.Data.SearchOrder.ZOrder, GrapeCity.Xaml.SpreadSheet.Data.SearchFoundFlags.CellText, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.Cells, out rowfound, out colfound);
//gcSpreadSheet1.Search(0, "test", GrapeCity.Xaml.SpreadSheet.Data.SearchFlags.ExactMatch, GrapeCity.Xaml.SpreadSheet.Data.SearchOrder.ZOrder, GrapeCity.Xaml.SpreadSheet.Data.SearchFoundFlags.CellText, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.Cells, 0, 0, out rowfound, out colfound);
//gcSpreadSheet1.Search(0, "test", GrapeCity.Xaml.SpreadSheet.Data.SearchFlags.ExactMatch, GrapeCity.Xaml.SpreadSheet.Data.SearchOrder.ZOrder, GrapeCity.Xaml.SpreadSheet.Data.SearchFoundFlags.CellText, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.Cells, 0, 0, 7, 7, out rowfound, out colfound);
//gcSpreadSheet1.Search(0, 1, "test", GrapeCity.Xaml.SpreadSheet.Data.SearchFlags.ExactMatch, GrapeCity.Xaml.SpreadSheet.Data.SearchOrder.ZOrder, GrapeCity.Xaml.SpreadSheet.Data.SearchFoundFlags.CellText, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.Cells, 0, 0, 7, 7, out sheetfound, out rowfound, out colfound);
gcSpreadSheet1.Search(0, 0, "test", GrapeCity.Xaml.SpreadSheet.Data.SearchFlags.ExactMatch, GrapeCity.Xaml.SpreadSheet.Data.SearchOrder.ZOrder, GrapeCity.Xaml.SpreadSheet.Data.SearchFoundFlags.CellText, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.Cells, 0, 0, 7, 7, out sheetfound, out rowfound, out colfound, out foundstring);
listBox1.Items.Add(colfound.ToString());                     
        }
GcSpreadSheet1.Sheets(0).Cells(5, 4).Text = "test"

Private Sub Button_Click_1(sender As Object, e As RoutedEventArgs)
        Dim colfound As Integer
        Dim rowfound As Integer
        Dim sheetfound As Integer
        Dim foundstring As String
        colfound = 0
        rowfound = 0
        sheetfound = 0
        foundstring = ""
        gcSpreadSheet1.SheetCount = 2
        'GcSpreadSheet1.Search(0, "test", rowfound, colfound)
        'GcSpreadSheet1.Search(0, "test", GrapeCity.Xaml.SpreadSheet.Data.SearchFlags.ExactMatch, rowfound, colfound)
        'GcSpreadSheet1.Search(0, "test", GrapeCity.Xaml.SpreadSheet.Data.SearchFlags.ExactMatch, GrapeCity.Xaml.SpreadSheet.Data.SearchOrder.ZOrder, rowfound, colfound)
        'GcSpreadSheet1.Search(0, "test", GrapeCity.Xaml.SpreadSheet.Data.SearchFlags.ExactMatch, GrapeCity.Xaml.SpreadSheet.Data.SearchOrder.ZOrder, GrapeCity.Xaml.SpreadSheet.Data.SearchFoundFlags.CellText, rowfound, colfound)
        'GcSpreadSheet1.Search(0, "test", GrapeCity.Xaml.SpreadSheet.Data.SearchFlags.ExactMatch, GrapeCity.Xaml.SpreadSheet.Data.SearchOrder.ZOrder, GrapeCity.Xaml.SpreadSheet.Data.SearchFoundFlags.CellText, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.Cells, rowfound, colfound)
        'GcSpreadSheet1.Search(0, "test", GrapeCity.Xaml.SpreadSheet.Data.SearchFlags.ExactMatch, GrapeCity.Xaml.SpreadSheet.Data.SearchOrder.ZOrder, GrapeCity.Xaml.SpreadSheet.Data.SearchFoundFlags.CellText, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.Cells, 0, 0, rowfound, colfound)
        'GcSpreadSheet1.Search(0, "test", GrapeCity.Xaml.SpreadSheet.Data.SearchFlags.ExactMatch, GrapeCity.Xaml.SpreadSheet.Data.SearchOrder.ZOrder, GrapeCity.Xaml.SpreadSheet.Data.SearchFoundFlags.CellText, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.Cells, 0, 0, 7, 7, rowfound, colfound)
        'GcSpreadSheet1.Search(0, 1, "test", GrapeCity.Xaml.SpreadSheet.Data.SearchFlags.ExactMatch, GrapeCity.Xaml.SpreadSheet.Data.SearchOrder.ZOrder, GrapeCity.Xaml.SpreadSheet.Data.SearchFoundFlags.CellText, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.Cells, 0, 0, 7, 7, sheetfound, rowfound, colfound)
        gcSpreadSheet1.Search(0, 0, "test", GrapeCity.Xaml.SpreadSheet.Data.SearchFlags.ExactMatch, GrapeCity.Xaml.SpreadSheet.Data.SearchOrder.ZOrder, GrapeCity.Xaml.SpreadSheet.Data.SearchFoundFlags.CellText, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.Cells, 0, 0, 7, 7, sheetfound, rowfound, colfound, foundstring)
        ListBox1.Items.Add(colfound.ToString())
    End Sub
Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         GrapeCity.Xaml.SpreadSheet.Data.SearchFoundFlags

Requirements

Target Platforms: Windows Server 2012, Windows RT

See Also

Reference

GrapeCity.Xaml.SpreadSheet.Data Namespace

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options