枚举: ComparisonOperators

Sheets.ConditionalFormatting.ComparisonOperators

比较运算符

代码示例

spread.options.highlightInvalidData = true;
var dv = GC.Spread.Sheets.DataValidation.createDateValidator(GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators.between, new Date(2012, 11, 31), new Date(2013, 11, 31));
dv.showInputMessage(true);
dv.inputMessage("Enter a date between 12/31/2012 and 12/31/2013.");
dv.inputTitle("Tip");
activeSheet.getCell(1, -1).validator(dv);

Table of contents

枚举值成员

• between
• equalsTo
• greaterThan
• greaterThanOrEqualsTo
• lessThan
• lessThanOrEqualsTo
• notBetween
• notEqualsTo

枚举值成员

between

• between = 6

单元格值是否在两个参数值之间

equalsTo

• equalsTo = 0

单元格值是否等于参数值

greaterThan

• greaterThan = 2

单元格值是否大于参数值

greaterThanOrEqualsTo

• greaterThanOrEqualsTo = 3

单元格值是否大于或等于参数值

lessThan

• lessThan = 4

单元格值是否小于参数值

lessThanOrEqualsTo

• lessThanOrEqualsTo = 5

单元格值是否小于或等于参数值

notBetween

• notBetween = 7

值是否不在两个参数值之间

notEqualsTo

• notEqualsTo = 1

单元格值是否不等于参数值