title: Problem with generating array with data from Spreadsheet
body: <p>I have a problem with getting data into array from Google Spreadsheet. I have a custom range set up, but instead of getting data, while logging the array I get an empty array.</p>
  <p>Code there the issue is:</p>
  <pre><code>  const ss = SpreadsheetApp.openById(&quot;ssid&quot;);
    const s = ss.getSheetByName(&quot;Events&quot;);
    const srange = s.getRange(2, 1, s.getLastRow(), 8);
    //var rangeArray = s.getDataRange().getValues();
    var rangeArray = srange.getValues().slice(-2)[0];
    Logger.log(&quot;rangeArray value: &quot;, rangeArray);
  </code></pre>
  <p>I expect to get a full array in rangeArray to work on it and create documents, but rangeArray variable is empty. Where is an error?</p>