Apparently, you must get a new reference to the spreadsheet after each write action. Once I put the Read action inside the loop, it started working. Anyone know how to cause the formulas to update based on the updated data?
-----Original Message----- From: Bill Franklin Sent: Thursday, September 08, 2011 12:32 PM To: cf-talk Subject: CF9 - SpreadsheetSetCellValue exception Okay, I have a spreadsheet loaded up. I am trying to create multiple copies of the spreadsheet on the server with different sets of values set in them. So, I have an index based loop..0 to 9 First run through, seems to go okay (although the formulas won't update based on the new values, unless I manually edit the cell and press enter...haven't looked into that yet). Second run through, blows up on the SpreadsheetSetCellValue command. It is setting the same cell's value to a different value on each pass through (3 cells total are getting changed on each pass). Error is: An exception occurred while calling the function setCellValue. org.apache.xmlbeans.impl.values.XmlValueDisconnectedException The error occurred in E:\http\test\test.cfm: line 19 17 : ---> 18 : 19 : <cfset SpreadsheetSetCellValue(ss,111,3,19)> 20 : <cfset SpreadsheetSetCellValue(ss,222,3,20)> 21 : <cfset SpreadsheetSetCellValue(ss,333,3,21)> Is the spreadsheet variable "ss" getting de-referenced when I perform the write action on the cfspreadsheet (occurs on line 22, right before the </cfloop>)? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347326 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm