title: The result of the method spreadsheetAddRow cannot be assigned because it does not return a value
body: <p>I have the following code which appears completely fine but keeps throwing the error: "The result of the method spreadsheetAddRow cannot be assigned because it does not return a value" This error is occurring at the row where I add the header. Nothing seems out of place and extensive google searching hasn't helped find anyone that has had a similar error. Hope the community can help!</p>
  
  <pre><code>&lt;cfset newSheet = spreadsheetNew('Need Approval')&gt;
  &lt;cfset headerRow = spreadsheetAddRow(newSheet,'ContactID,FirstName,LastName,Organization,RegisterDate,Approve,Deny')&gt;
  &lt;cfset i = 2&gt;
  &lt;cfoutput query="getNotApproved"&gt;
  &lt;cfset newRow = spreadsheetAddRow(newSheet,'#ContactID#,#FirstName#,#LastName#,#Organization#,#RegisterDate#',#i#,1)&gt;
  &lt;cfset addApprove = spreadsheetSetCellFormula(newSheet,"HYPERLINK(https://mysite/approvalStatus.cfm?sts=approved&amp;cid=#ContactID#&amp;udf=#getShowrooms.Showroom#,'Click here to Approve')",#i#,6)&gt;
  &lt;cfset addDeny = spreadsheetSetCellFormula(newSheet,"HYPERLINK(https://mysite/approvalStatus.cfm?sts=deny&amp;cid=#ContactID#&amp;udf=#getShowrooms.Showroom#,'Click here to Deny')",#i#,7)&gt;
  &lt;cfset i++&gt;
  &lt;/cfoutput&gt;
  </code></pre>