SpreadJS 13
GC.Spread.Sheets.Search Namespace / SearchCondition type
In This Topic
    SearchCondition type
    In This Topic
    Defines the search condition.
    Syntax
    var instance = new GC.Spread.Sheets.Search.SearchCondition();
    function SearchCondition;
    Example
    activeSheet.getCell(5,4).text("testSearch");
    var searchCondition = new GC.Spread.Sheets.Search.SearchCondition();
    searchCondition.searchString = "testSearch";
    searchCondition.startSheetIndex = spread.getActiveSheetIndex();
    searchCondition.endSheetIndex = spread.getActiveSheetIndex();
    searchCondition.searchOrder = GC.Spread.Sheets.Search.SearchOrder.nOrder;
    searchCondition.searchTarget = GC.Spread.Sheets.Search.SearchFoundFlags.cellText;
    searchCondition.searchFlags = GC.Spread.Sheets.Search.SearchFlags.ignoreCase| GC.Spread.Sheets.Search.SearchFlags.useWildCards;
    var searchresult= spread.search(searchCondition);
    var str ="[searchFoundFlag:"+ searchresult.searchFoundFlag+",\r\n foundSheetIndex:"+searchresult.foundSheetIndex+",foundRowIndex:" + searchresult.foundRowIndex+", * foundColumnIndex:"+searchresult.foundColumnIndex+", foundString:"+searchresult.foundString+"]";
    alert(str);
    Inheritance Hierarchy

    Object
       GC.Spread.Sheets.Search.SearchCondition

    Constructors
     NameDescription
    public ConstructorDefines the search condition.  
    Top
    Fields
     NameDescription
    public FieldThe index of the column at which to end.  
    public FieldThe index of the column at which to start.  
    public FieldIndex of the sheet on which to end searching.  
    public FieldThe index of the row at which to end.  
    public FieldThe index of the row at which to start.  
    public FieldThe enumeration that specifies the options of the search.  
    public FieldThe enumeration that specifies whether the search goes by coordinates of (column, row) or (row, column).  
    public FieldThe string for which to search.  
    public FieldThe enumeration that indicates whether the search includes the content in the cell notes, tags, or text.  
    public FieldThe area of the sheet for search.  
    public FieldIndex of the sheet on which to start searching.  
    Top
    See Also