LG设备上的字体大小太大(Font Size too big on LG device)

 在Javascript（以及因此在Google Apps脚本中），只有在目标对象“拥有”该方法时才能调用方法。 您收到错误是因为您混淆了一些对象 - 对象类型不支持您正在使用的方法。 （同意Serge的评论！） 
 
 您遇到的错误是： 
 
 
 
 在第三行代码中， dataLastRow = dataSheet.getLastRow()产生一个Number，然后尝试dataLastRow.getRange() 。 但是， .getRange()是一个Sheet方法。 
 
 
 之后， destLastRow = destSheet.getLastRow()产生另一个Number。 下一行有两个错误。 第一个是将此Number视为数组destLastRow[0] 。 
 
 
 该行中的第二个错误是在未定义的值上调用Range.setValue() 。 （它未定义，因为数组索引不正确。） 
 
 
 在其下方， var ID = destLastRow[1]重复错误＃2。 
 
 
 此编辑版本删除了这些错误。 它可能在逻辑上有其他错误，它肯定不完整，但它运行。 添加了注释以显示每个语句返回的对象类型。 
 
function sendData() {

  var sourceSS = SpreadsheetApp.getActiveSpreadsheet();      //= Spreadsheet
  var dataSheet = sourceSS.getSheetByName("Data");           //= Sheet
  var dataLastRow = dataSheet.getLastRow();                  //= Number
  var dataValues = dataSheet.getRange("A"+(dataLastRow)+":G"+(dataLastRow)).getValues();
                                                             //= Array [[]]

  var emailSheet = sourceSS.getSheetByName('Emails');        //= Sheet
  var recipient = emailSheet.getRange('B2:B22').getValues(); //= Array [[]]
  var orgUnit = emailSheet.getRange('A2:A22').getValues();   //= Array [[]]

  var destSS = SpreadsheetApp.openById('SHEETID');           //= Spreadsheet
  var destSheet = destSS.getSheetByName('Sheet1');           //= Sheet
  var destLastRow = destSheet.getLastRow();                  //= Number
  var type = destSheet.getRange(destLastRow, 0);             //= Range
  type.setValue('NEW');                                      //= Range (for chaining)
  var ID = destSheet.getRange(destLastRow, 1);               //= Range

}
 
 
 自动填充作为缺陷清除工具 
 
 在这种情况下，Apps脚本编辑器的自动完成功能是您的朋友。 当编辑器能够确定您正在处理的对象类型时，它将提供支持的方法列表。 如果您开始输入var dataValues = dataSheet.getR... ，您会看到以下内容： 
 
 
 只要你输入. ，编辑提供了一长串方法。 随着键入的字符越来越多，列表越来越短 - 此时您会看到各种Sheet.getRange()方法。 
 
 另一方面，这是当我们输入var dataValues = dataLastRow.时会发生什么var dataValues = dataLastRow. ： 
 
 
 不多。 编辑器没有为此类型提供的自动完成方法Number 。 如果您在编辑时调整了此行为，则可以避免许多以后可能具有高PITA因子的简单错误。 

In Javascript (and therefore in Google Apps Script), a method can only be invoked if the target object "has" that method. You're getting errors because you've mixed up some of your objects - the object types don't support the methods that you're using. (Agreeing with Serge's comment!)
 
The errors you have are:
 
 
 
In the third line of code, dataLastRow = dataSheet.getLastRow() yields a Number, then you try dataLastRow.getRange(). However, .getRange() is a Sheet method.
 
 
Later, destLastRow = destSheet.getLastRow() yields another Number. The next line has two errors. The first is that this Number is treated as an Array, destLastRow[0].
 
 
The second error in that line is invoking Range.setValue() on an undefined value. (It's undefined because the Array indexing is incorrect.)
 
 
Just below that, var ID = destLastRow[1] repeats error #2.
 
 
This edited version removes those errors. It may have other errors in logic, and it's certainly not complete, but it runs. Comments have been added to show what object types are returned with each statement.
 
function sendData() {

  var sourceSS = SpreadsheetApp.getActiveSpreadsheet();      //= Spreadsheet
  var dataSheet = sourceSS.getSheetByName("Data");           //= Sheet
  var dataLastRow = dataSheet.getLastRow();                  //= Number
  var dataValues = dataSheet.getRange("A"+(dataLastRow)+":G"+(dataLastRow)).getValues();
                                                             //= Array [[]]

  var emailSheet = sourceSS.getSheetByName('Emails');        //= Sheet
  var recipient = emailSheet.getRange('B2:B22').getValues(); //= Array [[]]
  var orgUnit = emailSheet.getRange('A2:A22').getValues();   //= Array [[]]

  var destSS = SpreadsheetApp.openById('SHEETID');           //= Spreadsheet
  var destSheet = destSS.getSheetByName('Sheet1');           //= Sheet
  var destLastRow = destSheet.getLastRow();                  //= Number
  var type = destSheet.getRange(destLastRow, 0);             //= Range
  type.setValue('NEW');                                      //= Range (for chaining)
  var ID = destSheet.getRange(destLastRow, 1);               //= Range

}
 
 
Autocomplete as a defect removal tool
 
In this situation, the Autocomplete feature of the Apps Script Editor is your friend. When the editor is able to determine what object type you're dealing with, it will offer a list of supported methods. Here's what you see if you start typing var dataValues = dataSheet.getR...:
 
 
As soon as you typed ., the editor offered up a long list of methods. As more characters were typed, the list got shorter - and at this point you see a variety of Sheet.getRange() methods.
 
On the other hand, here's what happens when we type var dataValues = dataLastRow.:
 
 
Not much. The editor has no autocomplete methods to offer for this type, Number. If you're tuned in to this behavior as you edit, you can avoid many simple mistakes that can have a high PITA factor later.