On Thu, 25 Jul 2013, rickhunter wrote:
I have problem with a formule in ExcelWhen 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 OKis there a reason ?thanks for your help.
Have you forgotten to re-create the cached formula values after setting the new formula? See http://poi.apache.org/spreadsheet/eval.html for how to do that
Nick --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
