title: Set the content of a cell to a function?
body: <p>I have a spreadsheet in which I want to be able to expand the number of columns using a function rather than using auto-fill because the new cells are getting filled with content based on complex formulas and depending on a lot of things.
  In one of these cells I want the content to be something like <code>=SUM(A1:A8)</code>
  But if I just do <code>cell.setValue("=SUM(A1:A8)")</code> I get "error: Unknown range name A1", unless I afterwards edit the cell content and press enter, without really having changed its content.</p>
  
  <p>Is there any way of fixing this?
  I don't want the calculation to be in the expand-columns-function because I do want the cell-calculation to be updated when one of the referenced cells change.
  Is there a way of doing it besides having an <code>onEdit</code>-function listening to changes in the referenced cells and updating the calculations?</p>
  
  <p>Thanks</p>