Thanks a lot for the answers. Yes I am sure about the version. I made a new test project and it works with a new test excel but still fails for our real excel. Problem is the real excel is both very complex and has lots of confidential client data. I will try to track the bug down but it is not easy.
Outlook for Android<https://aka.ms/ghei36> herunterladen On Fri, Oct 12, 2018 at 8:10 PM +0200, "Yegor Kozlov" <[email protected]<mailto:[email protected]>> wrote: Are you sure you are using POI 4.0? IFERROR is implemented and we have passing unit test for it. Yegor пт, 12 окт. 2018 г., 17:11 Stephen Friedrich : > I am using POI 4.0 and if I understood it correctly, then IFERROR function > should have been implemented long ago, right? > > Then why do I get this exception? > > Caused by: org.apache.poi.ss.formula.eval.NotImplementedFunctionException: > _XLFN.IFERROR > at > org.apache.poi.ss.formula.UserDefinedFunction.evaluate(UserDefinedFunction.java:56) > at > org.apache.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:146) > at > org.apache.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:534) > at > org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:275) > >
