...
以下代码创建一个可用值的列表,显示一个提示信息。当输入错误时,会显示一个错误图片。
Code Block | ||||
---|---|---|---|---|
|
...
Copy Code
spread.options.highlightInvalidData = true; var dv = GC.Spread.Sheets.DataValidation.createListValidator("1,2,3"); dv.showInputMessage(true); dv.inputMessage("Value must be 1,2 or 3"); dv.inputTitle("tip"); activeSheet.setDataValidator(1,1,dv); alert(activeSheet.getDataValidator(1,1).getValidList(activeSheet,1,1)); |
...
示例代码
以下代码使用了数字数据校验,显示了一个输入提示信息,当输入错误时,会显示一个错误图片。
Code Block | ||||
---|---|---|---|---|
|
...
Copy Code
spread.options.highlightInvalidData = true; var dv = GC.Spread.Sheets.DataValidation.createNumberValidator(GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators.Between, "5", "20", true); dv.showInputMessage(true); dv.inputMessage("Value must be between 5 and 20."); dv.inputTitle("tip"); activeSheet.setDataValidator(1, 1, dv); |
...
示例代码
以下代码使用了文本长度数据校验,显示了一个输入提示信息,当输入错误时,会显示一个错误图片。
Code Block | ||||
---|---|---|---|---|
|
...
Copy Code
spread.options.highlightInvalidData = true; var dv = GC.Spread.Sheets.DataValidation.createTextLengthValidator(GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators.GreaterThan, "4", "20"); dv.showInputMessage(true); dv.inputMessage("Number of characters must be greater than 4."); dv.inputTitle("tip"); activeSheet.setDataValidator(1, 1, dv); |
...
示例代码
以下例子通过公式校验器使用一个单元格区域来创建了可能值的列表用于数据校验。
Code Block | ||||
---|---|---|---|---|
|
...
Copy Code
activeSheet.setValue(0, 2, 5); activeSheet.setValue(1, 2, 4); activeSheet.setValue(2, 2, 5); spread.options.highlightInvalidData = true; var dv = GC.Spread.Sheets.DataValidation.createFormulaListValidator("$C$1:$C$3"); dv.showInputMessage(true); dv.inputMessage("Pick a value from the list."); dv.inputTitle("tip"); activeSheet.setDataValidator(1, 1, dv); var validList = activeSheet.getDataValidator(1, 1).getValidList(sheet, 1, 1); |
...
示例代码
以下代码使用了日期的数据校验
Code Block | ||||
---|---|---|---|---|
|
...
Copy Code
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.setDataValidator(1, 1, dv); |
...
示例代码
以下代码使用了公式的数据校验。
Code Block | ||||
---|---|---|---|---|
|
...
Copy Code
spread.options.highlightInvalidData = true; //The formula validator is valid if the formula condition returns true. var dv = GC.Spread.Sheets.DataValidation.createFormulaValidator("A1>0"); dv.showInputMessage(true); dv.inputMessage("Enter a value greater than 0 in A1."); dv.inputTitle("Tip"); activeSheet.setDataValidator(0, 0, dv); |
...
另见