poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rickhunter <w.dep...@specinov.fr>
Subject formula results in #value in excel
Date Mon, 29 Jul 2013 07:37:34 GMT
Dear all,

I have problem with a formule in Excel 
When i wrote this formula (=IF(LEN(A5)>4,MID(A4,4,2),A4)) with POI, when
condition is true, i have a #VALUE in cell. 
But with this formula (MID(A4,4,2)), all is OK is there a reason ? 

The formula is not calculate by POI (Eval).

I have delegate recalculation to Excel.

When I use F9 key in Excel, nothing happens. But when I revalidate the cell,
formula was recalculate.

thanks for your help. 

View this message in context: http://apache-poi.1045710.n5.nabble.com/formula-results-in-value-in-excel-tp5713350.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

View raw message