title: Inserting Hyperlinks in the new Google Sheets with App Script
body: <p>In the current version of Google Sheet, to insert a hyperlink in to a cell, you would do this</p>
  
  <pre><code>sheet.getRange(row, selectedColumn).setValue('=hyperlink("' + ontologyObject.accession + '";"' + ontologyObjectTerm + '")')
  </code></pre>
  
  <p>In the <strong>new</strong> version of Google Sheets, the hyperlink insertion is different, you do this.</p>
  
  <pre><code>sheet.getRange(row, selectedColumn).setValue('=HYPERLINK("' + ontologyObject.accession + '","' + ontologyObjectTerm + '")')
  </code></pre>
  
  <p>However, I have a problem in that the inserted value in the spreadsheet is not what I expect. In this image <a href="http://i.stack.imgur.com/oa1UA.png">showing the inserted link</a>, there is a ' inserted before the =HYPERLINK - I've no idea where this is coming from. Any ideas?</p>