将复选框重新设置为true（处理空格）-Google Apps脚本 [英] Re-set checkboxes to true (dealing with blanks)- Google Apps Script

问题描述

我在下面找到了以下代码段：将复选框重置为false -Google Apps脚本

I found the snippet below here: Re-set checkboxes to false - Google Apps Script

我有兴趣对其进行编辑以将false复选框设置为true，特别是将其添加为跳过空白单元格。找不到有助于跳过空格的内容。

I'm interested in editing this to set false checkboxes to true, specifically adding to it to skip blank cells. Can't find anything helpful on skipping blanks.

function resetCheckBoxesAllSheets() {
var ss = SpreadsheetApp.getActive();
var allsheets = ss.getSheets();
for (var s in allsheets){
var sheet=allsheets[s]

var dataRange = sheet.getRange('A4:Z100');
var values = dataRange.getValues();
for (var i = 0; i < values.length; i++) {
  for (var j = 0; j < values[i].length; j++) {
    if (values[i][j] == true) {
      values[i][j] = false;
    }
  }
}
dataRange.setValues(values);


}
}

推荐答案

如果希望翻转一组复选框的值，则将在给定的列活动范围内执行此操作：

If you wish to flip flop the values of a set of checkboxes this will do it for a given column active range:

注意：大写计数，是的，它们是字符串。如果对此有任何疑问，请使用脚本编辑器的调试器查看复选框中的内容。

Note: capitalization counts and yes those are strings. If you have any doubts about it then use your script editor's debugger to see what is in your checkboxes. That's how I figured it out when I started playing with them.

function resetCheckBoxesAllSheets() {
  var ss = SpreadsheetApp.getActive();
  var sheet=ss.getActiveSheet()
  var dataRange = sheet.getActiveRange();
  var values = dataRange.getValues();
  for (var i=0;i<values.length;i++) {
    values[i][0]=values[i][0]?"FALSE":"TRUE";
  }
  dataRange.setValues(values);
}

因此，在您的特定情况下，假设函数中的其他所有功能都有效，请尝试以下操作：

So in your particular case, assuming everything else in your function works then try this:

function resetCheckBoxesAllSheets() {
  var ss = SpreadsheetApp.getActive();
  var allsheets = ss.getSheets();
  for (var s in allsheets){
    var sheet=allsheets[s]
    var dataRange = sheet.getRange('A4:Z100');
    var values = dataRange.getValues();
    for (var i = 0; i < values.length; i++) {
      for (var j = 0; j < values[i].length; j++) {
        if (values[i][j]) {
          values[i][j] = "FALSE";
        }
      }
    }
    dataRange.setValues(values); 
  }
}

这篇关于将复选框重新设置为true（处理空格）-Google Apps脚本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！