You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@poi.apache.org by limette <in...@dablnet.de> on 2010/07/22 22:20:19 UTC

Error #VALUE with evaluateFormulaCell - but only sometimes

Hello,

I have a column with a formula.

=IF(($AE51+$AF51)=0;0;$AA51/($AE51+$AF51)*AE51)

The most results are fine. But a few are buggy with the Error "#VALUE".

What is the reason for this?

If I open the Excel file, and clicking at the cell with the error and press
enter, the correct result is there.
At the cell with the VALUE bug is a yellow exclamation point. Over this I
get the alert "Circular References".
Any idea...?

-- 
View this message in context: http://old.nabble.com/Error--VALUE-with-evaluateFormulaCell---but-only-sometimes-tp29239234p29239234.html
Sent from the POI - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org