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: [email protected] For additional commands, e-mail: [email protected]
