poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nick Burch <nick.bu...@alfresco.com>
Subject Re: evaluateFormulaCell() gives #VALUE! in excel cell.
Date Thu, 20 Jan 2011 12:39:26 GMT
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message