Hi Nick, As per as I know cache value concept will only come into picture if I have evaluated once already.But I am evaluating it for the first time. Let me know if I am wrong. Still I would verify and let you know. And it's not happening for all the formulas.I saw for TRIM,VALUE etc. Also I implemented CLEAN and ADDRESS(they are now part of POI 3.8 dev) for them also I see the issue.
On Thu, Jan 20, 2011 at 5:39 PM, Nick Burch <[email protected]> wrote: > On Thu, 20 Jan 2011, Aniket Banerjee wrote: > >> After resetting formula in an excel cell we need to evaluate to get the >> result. Now for few function like TRIM if I use evaluateFormulaCell() (which >> stores both cell and formula in the cell) I get #VALUE!. But when I debugged >> the source code I see it gives the correct result but still excel gives >> error. >> > > Are you getting this for all formulas, or just some? > > If you look at the cached value using poi, do you see the correct one? Does > poi see an error value set on the cell? > > Nick > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
