SpreadJS 13
GC.Spread.Sheets.Search Namespace / SearchFlags Enumeration
In This Topic
    SearchFlags Enumeration
    In This Topic
    Specifies the type of search flags.
    Members
    MemberDescription
    blockRangeDetermines whether to search within a cell range.
    exactMatchDetermines whether the search considers only an exact match.
    ignoreCaseDetermines whether the search considers the case of the letters in the search string.
    noneSpecifies no search flags.
    useWildCardsDetermines whether the search considers wildcard characters (*, ?) in the search string.
    Example
    This example uses the SearchFlags 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.SearchFlags

    See Also