------- Additional Comments From [hidden email] 2005-05-20 06:03 -------
(In reply to comment #3)
> Why would you want to direcly access fp from outside?
I've got a spread sheet that over time has gotten so complex that nobody really
understands how it works any more. It's six sheets and each sheet has hundreds
of columns of data, and each sheet combines data from the previous sheet in
linear ways to form aggregated and scaled data.
The end result with the formula parser was to take the a formula on page one and
unwind the calculations (parse the formula, go grab the cells it references, if
they are formulas, parse them, grab the cells they reference, etc.) until I get
a list of the source data (and the COMPLETE calculation as one forumla) that's
involved in each calculation on the first page.