枚举: SearchFlags

Sheets.Search.SearchFlags

搜索标签的类型

代码示例

//本示例使用SearchFlags枚举
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);

Table of contents

枚举值成员

• blockRange
• exactMatch
• ignoreCase
• none
• useWildCards

枚举值成员

blockRange

• blockRange = 8

是否在单元格区域内搜索

exactMatch

• exactMatch = 2

搜索是否仅考虑完全匹配

ignoreCase

• ignoreCase = 1

搜索是否考虑搜索字符串中字母的大小写

none

• none = 0

不指定搜索标签

useWildCards

• useWildCards = 4

搜索是否在搜索字符串中考虑通配符(*,？)