startSheetIndex フィールド

検索を開始するシートのインデックス。

シンタックス

Javascript (Usage)
Javascript (Specification)

var instance = new GC.Spread.Sheets.Search.SearchCondition();
var value; // Type: number
value = instance.startSheetIndex;

var startSheetIndex : number;

使用例

次のサンプルコードは、startSheetIndexプロパティを設定します。

Javascript

// 次のサンプルコードは、セルのブロックを検索します。 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);

Javascript

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);

参照

SearchCondition タイプ