枚举: TextComparisonOperators

Sheets.ConditionalFormatting.TextComparisonOperators

文本比较运算符

代码示例

//本示例创建一个规则
var style = new GC.Spread.Sheets.Style();
style.backColor = "red";
var ranges=[new GC.Spread.Sheets.Range(0,0,10,1)];
activeSheet.conditionalFormats.addSpecificTextRule(GC.Spread.Sheets.ConditionalFormatting.TextComparisonOperators.contains, "test", style, ranges);
activeSheet.setValue(0, 0, "testing");
activeSheet.setValue(1, 0, "test");
activeSheet.setValue(2, 0, "a");
activeSheet.setValue(3, 0, "t");

Table of contents

枚举值成员

• beginsWith
• contains
• doesNotContain
• endsWith

枚举值成员

beginsWith

• beginsWith = 2

确定单元格值是否以参数值开头

contains

• contains = 0

确定单元格值是否包含参数值

doesNotContain

• doesNotContain = 1

确定单元格值是否不包含参数值

endsWith

• endsWith = 3

确定单元格值是否以参数值结尾