- var dv = GC.Spread.Sheets.DataValidation.createNumberValidator(
- GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators.between,
- "-999999999999999",
- "999999999999999",
- true
- );
- dv.errorMessage("在15位整数以内");
- dv.errorTitle("错误");
- dv.showErrorMessage(true);
- dv.ignoreBlank(true);
- dv.highlightStyle({
- type: GC.Spread.Sheets.DataValidation.HighlightType.icon,
- color: "red",
- position:
- GC.Spread.Sheets.DataValidation.HighlightPosition.outsideRight,
- });
- sheet.setDataValidator(0, 0, dv, GC.Spread.Sheets.SheetArea.viewport);
复制代码 数字:4697.88649220819 没有超过限制吧,为什么校验错误啊??虽然字符串长度确实超过了15,但是值本身没到 999999999999999啊 ,这个不是比较值本身吗?
|