SpreadJS 13
GC.Spread.Sheets.Search Namespace / SearchFoundFlags Enumeration
In This Topic
    SearchFoundFlags Enumeration
    In This Topic
    Specifies where the search string is found.
    Members
    MemberDescription
    cellFormulaIndicates that the string is found in the cell formula.
    cellTagIndicates that the string is found in the cell tag.
    cellTextIndicates that the string is found in the cell text.
    noneIndicates that no string is found.
    Example
    This example uses the SearchFoundFlags enumeration.
    activeSheet.getCell(2,3).value("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= activeSheet.search(searchCondition);
    
    var str ="[searchFoundFlag:"+ searchresult.searchFoundFlag+",\r\n foundSheetIndex:"+searchresult.foundSheetIndex+",foundRowIndex:" +
    searchresult.foundRowIndex+", foundColumnIndex:"+searchresult.foundColumnIndex+", foundString:"+searchresult.foundSheetIndex+"]";
    alert(str);
    Inheritance Hierarchy

    Object
       GC.Spread.Sheets.Search.SearchFoundFlags

    See Also