title: Copy a Range to another spreadsheet with data validations, formats etc
body: <p>I managed to copy values and formulas from one range to another spreadsheet range (of the same size).</p>
  <p><a href="https://stackoverflow.com/questions/45157101/google-apps-script-copy-range-from-one-spreadsheet-to-another-with-formats-for/45157778?noredirect=1#comment129496986_45157778">Copy range to another spreadsheet</a></p>
  <p>I need to copy formats, fonts, colors, borders, data validations etc to the new range in another spreadsheet.</p>
  <p>Is it possible?</p>