在Google Sheets脚本中使用复制/拖动功能计算粗体单元格

function calculateBoldCellSum() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var range = sheet.getDataRange();
  var values = range.getValues();
  var boldCellSum = 0;

  for (var i = 0; i < values.length; i++) {
    for (var j = 0; j < values[i].length; j++) {
      var cell = range.getCell(i + 1, j + 1);
      if (cell.getFontWeight() == "bold") {
        boldCellSum += values[i][j];
      }
    }
  }

  Logger.log("Sum of bold cells: " + boldCellSum);
}