Thanks for your answer. My 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.
De : Nick Burch-2 [via Apache POI] [mailto:[email protected]] Envoyé : jeudi 25 juillet 2013 12:13 À : Willy Deprez Objet : Re: #Value in excel with MID function 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: [hidden email]</user/SendEmail.jtp?type=node&node=5713327&i=0> For additional commands, e-mail: [hidden email]</user/SendEmail.jtp?type=node&node=5713327&i=1> ________________________________ If you reply to this email, your message will be added to the discussion below: http://apache-poi.1045710.n5.nabble.com/Value-in-excel-with-MID-function-tp5713326p5713327.html To unsubscribe from #Value in excel with MID function, click here<http://apache-poi.1045710.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=5713326&code=dy5kZXByZXpAc3BlY2lub3YuZnJ8NTcxMzMyNnwxNDkwNTgzMTk0>. NAML<http://apache-poi.1045710.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Value-in-excel-with-MID-function-tp5713326p5713328.html Sent from the POI - Dev mailing list archive at Nabble.com.
