>I have a workbook that I read with CFSpreadsheet, update some of the data, >and then write out to a new file. The problem that I'm running into is that >there are several formulas on the spreadsheet that don't recalculate when >the new file is saved. Even when the file is opened the formulas won't >recalculate until you retype one of them. Has anyone else run into a >problem like this?
Got it figured out. I had to add this just before the write to force it to reevaluate my formulas (it's in cfscript, obviously). wb=sheet.getWorkbook(); evalu=wb.getCreationHelper().createFormulaEvaluator(); evalu.evaluateAllFormulaCells(wb); There may be a way to do this without resorting to messing with the underlying Java object, but I couldn't manage to find it. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334477 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm