在谷歌脚本中有没有一种现有的方法来检查A1表示法是否在第二个A1表示法的范围内

function checkA1Range() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  
  var range1 = sheet.getRange("A1:B5");
  var range2 = sheet.getRange("C3:D7");
  
  var a1Notation1 = range1.getA1Notation();
  var a1Notation2 = range2.getA1Notation();
  
  var isInRange = isA1InRange(a1Notation1, a1Notation2);
  
  Logger.log("Range 1: " + a1Notation1);
  Logger.log("Range 2: " + a1Notation2);
  Logger.log("Is Range 1 in Range 2? " + isInRange);
}

function isA1InRange(a1Notation1, a1Notation2) {
  var range1Start = a1Notation1.split(":")[0];
  var range1End = a1Notation1.split(":")[1];
  
  var range2Start = a1Notation2.split(":")[0];
  var range2End = a1Notation2.split(":")[1];
  
  // 比较列号
  var col1Start = range1Start.replace(/[0-9]/g, '');
  var col1End = range1End.replace(/[0-9]/g, '');
  var col2Start = range2Start.replace(/[0-9]/g, '');
  var col2End = range2End.replace(/[0-9]/g, '');
  
  if (col1Start > col2End || col1End < col2Start) {
    return false;
  }
  
  // 比较行号
  var row1Start = parseInt(range1Start.replace(/\D/g, ''));
  var row1End = parseInt(range1End.replace(/\D/g, ''));
  var row2Start = parseInt(range2Start.replace(/\D/g, ''));
  var row2End = parseInt(range2End.replace(/\D/g, ''));
  
  if (row1Start > row2End || row1End < row2Start) {
    return false;
  }
  
  return true;
}