> For the complete documentation index, see [llms.txt](https://lochiwei.gitbook.io/web/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://lochiwei.gitbook.io/web/appendix/gas/app/prototypes/app.range.prototype/range.contains.md).

# range.contains()

[GAS](/web/appendix/gas.md) ⟩ [app](/web/appendix/gas/app.md) ⟩ [range](broken://pages/yBUzRclQF6ZBjZYXLBA9) ⟩ .contains()

{% tabs %}
{% tab title="💾 程式" %}

```javascript
// 🔸 app.range.contains(superRange, subRange)
app.range.contains = function(superRange, subRange) {

  // get first row #
  let r11 = superRange.getRow();
  let r21 = subRange.getRow();
  if (r11 > r21) return false;

  // get last row #
  let r12 = r11 + superRange.getNumRows() - 1;
  let r22 = r21 + subRange.getNumRows() - 1;
  if (r12 < r22) return false;

  // get first col #
  let c11 = superRange.getColumn();
  let c21 = subRange.getColumn();
  if (c11 > c21) return false;

  // get last col #
  let c12 = c11 + superRange.getNumColumns() - 1;
  let c22 = c21 + subRange.getNumColumns() - 1;
  if (c12 < c22) return false;

  return true;
}
```

{% endtab %}

{% tab title="💈範例" %}

```javascript
// 
function test_rangeContains() {

  let tempA = app.range.byName('tempA');
  let tempB = app.range.byName('tempB');
  let tempC = app.range.byName('tempC');
  let tempD = app.range.byName('tempD');

  app.log(`A contais B: ${app.range.contains(tempA, tempB)}`);  // false
  app.log(`A contais C: ${app.range.contains(tempA, tempC)}`);  // true
  app.log(`A contais D: ${app.range.contains(tempA, tempD)}`);  // true

  app.log(`B contais A: ${app.range.contains(tempB, tempA)}`);  // false
  app.log(`B contais C: ${app.range.contains(tempB, tempC)}`);  // false
  app.log(`B contais D: ${app.range.contains(tempB, tempD)}`);  // true

  app.printLogs();
}
```

![](https://2527454625-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MfvEFZnSBhKT6fJmus0%2Fuploads%2FIuEE9JfXNEH4HaoZXUvt%2Frange%20contains.png?alt=media\&token=98e6769d-25db-4e87-b122-55b40040d508)
{% endtab %}

{% tab title="📘 手冊" %}

* [Sheets](https://developers.google.com/apps-script/reference/spreadsheet?hl=en) ⟩ [Range](https://developers.google.com/apps-script/reference/spreadsheet/range?hl=en) ⟩&#x20;
  * [.getRow()](https://developers.google.com/apps-script/reference/spreadsheet/range?hl=en#getrow)
  * [.getColumn()](https://developers.google.com/apps-script/reference/spreadsheet/range?hl=en#getcolumn)
  * [.getNumRows()](https://developers.google.com/apps-script/reference/spreadsheet/range?hl=en#getnumrows)
  * [.getNumColumns()](https://developers.google.com/apps-script/reference/spreadsheet/range?hl=en#getnumcolumns)
    {% endtab %}
    {% endtabs %}