title: Copy entire columns including blank rows
body: <pre><code>  //Copy
    var ss = SpreadsheetApp.openById('AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA');
    var sss = ss.getSheetByName('Stats');
    var range = sss.getRange(1,7,sss.getLastRow(),5);
    var data = range.getValues();
  
    //Main_Event 1
    var ts = SpreadsheetApp.openById('BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB');
    var tss = ts.getSheetByName('Main_Event');
    tss.getRange(1,1, data.length, data[0].length).setValues(data);
  </code></pre>
  <p>Current results:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Sheet A</th>
  <th>Sheet A</th>
  <th>Sheet A</th>
  <th>Sheet A</th>
  <th>Sheet A</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>one</td>
  <td>two</td>
  <td>three</td>
  <td>four</td>
  <td>five</td>
  </tr>
  <tr>
  <td>new values</td>
  <td>new values</td>
  <td>new values</td>
  <td>new values</td>
  <td>new values</td>
  </tr>
  <tr>
  <td>new values</td>
  <td>new values</td>
  <td>new values</td>
  <td>new values</td>
  <td>new values</td>
  </tr>
  <tr>
  <td></td>
  <td></td>
  <td></td>
  <td></td>
  <td></td>
  </tr>
  <tr>
  <td></td>
  <td></td>
  <td></td>
  <td></td>
  <td></td>
  </tr>
  </tbody>
  </table>
  </div><div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Sheet B</th>
  <th>Sheet B</th>
  <th>Sheet B</th>
  <th>Sheet B</th>
  <th>Sheet B</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>one</td>
  <td>two</td>
  <td>three</td>
  <td>four</td>
  <td>five</td>
  </tr>
  <tr>
  <td>new values</td>
  <td>new values</td>
  <td>new values</td>
  <td>new values</td>
  <td>new values</td>
  </tr>
  <tr>
  <td>new values</td>
  <td>new values</td>
  <td>new values</td>
  <td>new values</td>
  <td>new values</td>
  </tr>
  <tr>
  <td>old values</td>
  <td>old values</td>
  <td>old values</td>
  <td>old values</td>
  <td>old values</td>
  </tr>
  <tr>
  <td>old values</td>
  <td>old values</td>
  <td>old values</td>
  <td>old values</td>
  <td>old values</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Expected result:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Sheet B</th>
  <th>Sheet B</th>
  <th>Sheet B</th>
  <th>Sheet B</th>
  <th>Sheet B</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>one</td>
  <td>two</td>
  <td>three</td>
  <td>four</td>
  <td>five</td>
  </tr>
  <tr>
  <td>new values</td>
  <td>new values</td>
  <td>new values</td>
  <td>new values</td>
  <td>new values</td>
  </tr>
  <tr>
  <td>new values</td>
  <td>new values</td>
  <td>new values</td>
  <td>new values</td>
  <td>new values</td>
  </tr>
  <tr>
  <td></td>
  <td></td>
  <td></td>
  <td></td>
  <td></td>
  </tr>
  <tr>
  <td></td>
  <td></td>
  <td></td>
  <td></td>
  <td></td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Sheet A: columns are filled up to row 85 and up to row 1000 they are blank.</p>
  <p>Sheet B: there are rows filled up to row 1000.</p>
  <p>So when I'm going to copy the values from A to B, I want the blank rows to take the place of the filled rows, being exactly the same as sheet A.</p>
  <p>But in my attempts the old values keep appearing from row 86 to 1000 and only the 85 rows filled in A that are modified in B.</p>
  <p>What am I doing wrong in my attempt?</p>
  <p>Additional information:</p>
  <p>When I try to do this same thing using the same code but sending the values within the same ID sheet, it works perfectly modifying the column completely including the blank rows.</p>
  <p>But when I try to do it using different ID sheets, it doesn't work.</p>