本帖最后由 dexteryao 于 2016-12-9 15:09 编辑
只能加一个。你可以用betweenvar dv = GC.Spread.Sheets.DataValidation.createNumberValidator(GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators.between, "5", "20", true);
有个更简单的方案。使用公式验证,这些单元格都设置这个公式
var dv = GC.Spread.Sheets.DataValidation.createFormulaValidator("=AND(0.95<(D27+D31)/D20,(D27+D31)/D20<1.05)");
dv.showInputMessage(true);
dv.inputMessage("Enter a value greater than 0 in A1.");
dv.inputTitle("Tip");
activeSheet.setDataValidator(0, 0, dv);
|