[Bug 53966] Support of =IFERROR(VLOOKUP()) formula

[bu...@apache.org]

https://issues.apache.org/bugzilla/show_bug.cgi?id=53966

--- Comment #3 from Johan <jo...@gmail.com> ---
Hi Yegor,

Sorry for the late reply.

How do I prepare the patch?

Regards,
Johan

(In reply to comment #2)
> You are very much welcome to contribute your implementation. 
> 
> Fell free if you need guidance how to prepare the patch. 
> 
> Yegor
> 
> (In reply to comment #1)
> > (In reply to comment #0)
> > > When we try to read data from a cell, which contains:
> > > 
> > > =IFERROR(VLOOKUP())
> > > 
> > > We get this error:
> > > 
> > > Caused by: org.apache.poi.ss.formula.eval.NotImplementedException: IFERROR
> > > at
> > > org.apache.poi.ss.formula.atp.AnalysisToolPak$NotImplemented.
> > > evaluate(AnalysisToolPak.java:40)
> > > at
> > > org.apache.poi.ss.formula.UserDefinedFunction.evaluate(UserDefinedFunction.
> > > java:64)
> > > at
> > > org.apache.poi.ss.formula.OperationEvaluatorFactory.
> > > evaluate(OperationEvaluatorFactory.java:129)
> > > at
> > > org.apache.poi.ss.formula.WorkbookEvaluator.
> > > evaluateFormula(WorkbookEvaluator.java:491)
> > > at
> > > org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.
> > > java:287)
> > > 
> > > Thanks for your support.
> > 
> > Hi,
> > 
> > I have recently implemented IFERROR since we needed it for a project and my
> > aim is to contribute this fix back to POI but I haven't had the time to do
> > it yet.
> > 
> > Regards,
> > Johan

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org