Resolving formulas in cfspreadsheet
Posted on 2010-08-24
I have a very complex spreadsheet sent to me each week containing payroll data which I need to extract. The spreadsheet contains several sheets and the summary page contains formulas in just about every cell, but this sheet contains the data I need.
Using cfspreadsheet and outputting it I get cell values like "fnnNormalWkOrdTime($A10,$EZ10-$FF10)-$FC10". How can I resolve the formulas to a numeric value like "8"? (Believe it or not, that is the value from that formula!)