I debugged the code and found one function *Find* gave result as error code 15. But the same happens for both the API's right? So how come evaluateInCell() works and evaluateFormulaCell() don't.
On Thu, Jan 20, 2011 at 6:09 PM, Nick Burch <[email protected]> wrote: > On Thu, 20 Jan 2011, Aniket Banerjee wrote: > >> 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. >> > > When you evaluate the cell, you save the result value back into the cell > for use by excel. Check if that shows the correct value, and also check to > see if there's an error on the cell before+after > > > Nick > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
