------- Additional Comments From [hidden email] 2005-05-20 13:33 -------
Ok, I get your usecase, and POI as it stands does not support this. And I am not
sure if I like any of the suggested solutions.
I'd thought of something like this a long time ago, and my preferred option was
to actually build a high level api for the formulas, so a method in HSSFCell
that would return the parsed formula, as an array of, for eg, CellReference
objects and HSSFFormulaOp(sic) objects. You could then traverse the tree.
Actually, with Amol's work, what I call the HSSFFormulaOp, could very well be
his Eval objects. It could all be tied up nicely.