Google电子表格脚本在一定范围内创建数据验证 [英] Google spreadsheet Script Create Data Validation in certain range

问题描述

我试图使用这个脚本来创建数据验证，但它总是不起作用

I'm trying this script to create data validation but it's always doesn't work

   function test_validation()
      {
      var Spread = SpreadsheetApp.getActiveSpreadsheet();
      var Sheet = Spread.getSheetByName('Sheet1'); 
      var validate1 = Sheet.getRange("A1").getDataValidation();
      Logger.log(validate1.getCriteria());
      Logger.log(validate1.getCriteriaValues());
      var option = new Array();
      option[0]="true";
      option[1]="1";
      option[2]="2";
      option[3]="3";
      var criteria="ITEM_IN_LIST";
      var helpText="Test Help Text"
      var Combobox = Sheet.getRange("A2").getDataValidation();
      //The line below display error 
      //"Cannot find method  (class)setCriteria(string,String[]). "
      Combobox.setCriteria(criteria,option);
      Combobox.setHelpText(helpText);
      var validate2 = Sheet.getRange("A2").setDataValidation(Combobox);
      Logger.log(Sheet.getRange("A2").getDataValidation().getCriteria());
      Logger.log(Sheet.getRange("A2").getDataValidation().getCriteriaValues());
       }

预先致谢

Thanks in advance.

推荐答案

我终于找到了答案2680

I found the answer finally in issue 2680

工作代码

the working code

        function test()
        {
        var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); 
        var option = new Array();
        option[0]="0";
        option[1]="1";
        option[2]="2";
        option[3]="3";
        var dv = sheet.getRange("A3").getDataValidation();
        dv.setAllowInvalidData(false);
        dv.setHelpText("Some help text here");
        dv.setCriteria(SpreadsheetApp.DataValidationCriteria.ITEM_IN_LIST,true,option );
        sheet.getRange("A3").setDataValidation(dv);
        }

这篇关于Google电子表格脚本在一定范围内创建数据验证的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！