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]
