Hi, 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. When I use evaluateInCell() gives me the correct result. But I want both result and the formula.
Is this a bug? Or do I need to do something else to achieve my requirement? Please help!!! Regards, Aniket
