title: Google Sheets Script getLastRow() not returning all values
body: <p>
  I have email addresses in first column. When I try to get the last row of this column, the function only returns the first two values. Here is a link to the sheet: <a href="https://docs.google.com/spreadsheets/d/1piGCiWMcUKUWagIJSZ_0SxxuNG3tcEcrx-fKnMDOIlQ/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1piGCiWMcUKUWagIJSZ_0SxxuNG3tcEcrx-fKnMDOIlQ/edit?usp=sharing</a></p>
  
  <p>
  Here is the script function:</p>
  
  <pre><code>function myFunction() {
    var rangeLastRow = SpreadsheetApp.getActive().getSheetByName('Sheet1').getRange(2, 1).getLastRow(); 
    var emails = SpreadsheetApp.getActive().getSheetByName('Sheet1').getRange(2, 1,rangeLastRow).getValues();
    Logger.log(emails);
  }
  </code></pre>
  
  <p>
  Shouldn't it be returning all of the email addresses in the first column?
  
  It is only returning the first two email addresses.</p>