目标范围的坐标超出图纸尺寸 [英] The coordinates of the target range are outside the dimensions of the sheet

问题描述

我使用此代码，并且在过去运行良好时，今天我收到此错误消息:

I use this code and while in the past it worked well, today I received this error message:

目标范围的坐标超出图纸尺寸. (第27行，___.gs)

The coordinates of the target range are outside the dimensions of the sheet. (line 27, ___.gs)

我的代码不太复杂:

function onEdit() {
  var sheetNameToWatch1 = "Assign_Page";
  var columnNumberToWatch = 19;
  var valueToWatch = "Delivred";
  var sheetNameToMoveTheRowTo = "K_Delivery_Archive";
  var sheetNameToMoveTheRowTo2 = "Buffering";

  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = SpreadsheetApp.getActiveSheet();
  var range = sheet.getActiveCell();

  if (sheet.getName() == sheetNameToWatch1 && range.getColumn() == columnNumberToWatch && range.getValue() == valueToWatch) {
    var targetSheet = ss.getSheetByName(sheetNameToMoveTheRowTo);
    var targetRange = targetSheet.getRange(targetSheet.getLastRow() + 1, 1);
    sheet.getRange(range.getRow(), 1, 1, 22).copyTo(targetRange, {contentsOnly: true});

    var targetSheet2 = ss.getSheetByName(sheetNameToMoveTheRowTo2); 
    var targetRange2 = targetSheet2.getRange(targetSheet2.getLastRow() + 1, 1);
    sheet.getRange(range.getRow(), 1, 1, 22).copyTo(targetRange2, {contentsOnly: true});

    sheet.deleteRow(range.getRow()); // line 27

    var Sheet1 = ss.getSheetByName("Clients_Page");
    var Sheet2 = ss.getSheetByName("Assign_Page");
    var Sheet3 = ss.getSheetByName("Report");
    var Sheet4 = ss.getSheetByName("Delivery_Information");
    Sheet4.showSheet();
    Sheet1.hideSheet();
    Sheet2.hideSheet();
    Sheet3.hideSheet();
  }
}

什么原因导致此错误，如何解决?

What causes this error, and how can I resolve it?

推荐答案

问题很可能是由于

targetSheet2.getLastRow()+ 1

正确的解决方案将取决于OP未提及的几个因素，但这是一个提示:

The proper solution will depend on several factors that are not mentioned by the OP, but here is a hint:

如果工作表具有返回""的开放式公式，则最后一行与工作表中的最大行数相同，并且插入更多行将无法解决问题.

If the sheet has open ended formulas that return "" then the last row is the same as the maximum number of rows in the sheet and inserting more rows will not solve the problem.

这篇关于目标范围的坐标超出图纸尺寸的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！