title: Copy and paste Value and Format Only - Google Script
body: <p>I'd like to copy and paste just values and format - not formula..</p>
  
  <p>E.G (A1 is a dynamic text):</p>
  
  <p>A1 = "test"</p>
  
  <p>A2 = <strong>=A1</strong></p>
  
  <p>I'd like to use a script that when activated it copy A2 format and text (in this case would copy "test" - not "=a1") to A3 . </p>
  
  <p>I tried with "formatOnly:true , contentsOnly:true" - but it keep copying formula.</p>
  
  <pre><code>function Threebrow() {  
     var sheet2 = SpreadsheetApp.getActive().getSheetByName('c');
    sheet2.getRange("a2").copyTo(sheet2.getRange(sheet2.getLastRow()+1,1,1,7), {formatOnly:true , contentsOnly:true});
  }
  </code></pre>