SpreadJS製品ヘルプ
sheetArea フィールド
GC.Spread.Sheets.Search 名前空間 > SearchCondition タイプ : sheetArea フィールド
検索するシートの領域。
シンタックス
var instance = new GC.Spread.Sheets.Search.SearchCondition();
var value; // Type: SheetArea
value = instance.sheetArea;
var sheetArea : SheetArea;
使用例
次のサンプルコードは、セルのブロックを検索します。
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);
関連トピック

参照

SearchCondition タイプ