您好,
根据电话沟通的结果,可以参考以下代码- <!DOCTYPE html>
- <html>
- <head>
- <title>SpreadJS Pluggable Sample</title>
- <link href="gcspread.sheets.8.40.20151.5.css" rel="stylesheet" type="text/css" />
- <script src="jquery-1.8.2.min.js" type="text/javascript"></script>
- <script type="text/javascript" src="gcspread.sheets.all.8.40.20151.5.min.js"></script>
- <script type="text/javascript">
- $(document).ready(function() {
- var spread = new GcSpread.Sheets.Spread($("#ss").get(0), {
- sheetCount: 3
- });
- var activeSheet = spread.getActiveSheet();
- activeSheet = spread.getSheet(0);
- spread.highlightInvalidData(true);
-
- var dv = GcSpread.Sheets.DefaultDataValidator.createFormulaValidator("A1>0");
- dv.showInputMessage = true;
- dv.inputMessage = "Enter a value greater than 0 in A1.";
- dv.inputTitle = "Tip";
- activeSheet.setDataValidator(0, 0, dv);
- activeSheet.setValue(0, 0, -1);
- $("#button1").click(function() {
- activeSheet.addRows(0, 1);
- });
-
- $("#button2").click(function () {
- alert(activeSheet.getDataValidator(1,0).condition.formula);
- });
- });
- </script>
- <body>
- <div id="ss" style="width: 600px; height: 400px; border: 1px solid gray">
- </div>
- <input type="button" id="button1" value="button1"/>
- <input type="button" id="button2" value="button2"/>
- </body>
- </html>
复制代码 |