title: why google app script 'copyTo' range method filling with 0?
body: <p>consider the following code:</p>
  
  <pre><code>/**********************************************************************************************
   **  FUNCTION : CarryToThisWeek                                                              **
   **  PARAM    : String lastWeekName, String thisWeekName                                     **
   **  RETUEN   : VOID                                                                         **
   **  DESC     : Copies the carry row of sheet named lastWeekName to B/F row of sheet named   **
   **             thisWeekName.                                                                **
   **********************************************************************************************/
  
  function CarryToThisWeek(lastWeekName,thisWeekName){
    var spreadSheet=SpreadsheetApp.getActiveSpreadsheet();
    var lastSheet=spreadSheet.getSheetByName('Oct_06'); // hard-coded the names for testing
    var thisSheet=spreadSheet.getSheetByName('Oct_13');
    var sourceData = lastSheet.getRange(38, 4, 1, 7);
    Logger.log(sourceData.getValues()); //shows the correct values
    var destination = thisSheet.getRange(33, 4, 1, 7);
    sourceData.copyTo(destination); //fills with 0 &lt;&lt;&lt;&lt;&lt;
    //following loop works fine
    /*for(col=4;col&lt;=10;col++){
      thisSheet.getRange(33, col).setValue(lastSheet.getRange(38, col).getValue());
    }*/
  }
  </code></pre>
  
  <p>I am fairly new to google app scripts, though I have used the <code>copyTo</code> method successfully in some other place previously.</p>
  
  <p>I fear I am missing something very silly.</p>
  
  <p>Can someone please point me to what i am doing wrong? </p>