SpreadJS 14
GC.Spread.Sheets.Search Namespace / SearchCondition type / sheetArea Field
In This Topic
    sheetArea Field
    In This Topic
    The area of the sheet for search.
    Syntax
    var instance = new GC.Spread.Sheets.Search.SearchCondition();
    var value; // Type: SheetArea
    value = instance.sheetArea;
    var sheetArea : SheetArea;
    Example
    This example searches a block of cells.
    activeSheet.getCell(0,0).text("testSearch");
    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.columnStart = 1;
    searchCondition.columnEnd = 10;
    searchCondition.rowStart = 1;
    searchCondition.rowEnd = 10;
    searchCondition.sheetArea = GC.Spread.Sheets.SheetArea.viewport;
    searchCondition.searchOrder = GC.Spread.Sheets.Search.SearchOrder.nOrder;
    searchCondition.searchTarget = GC.Spread.Sheets.Search.SearchFoundFlags.cellText;
    searchCondition.searchFlags = GC.Spread.Sheets.Search.SearchFlags.blockRange;
    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);
    See Also