poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 53966] Support of =IFERROR(VLOOKUP()) formula
Date Mon, 22 Oct 2012 11:59:21 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=53966

--- Comment #1 from Johan <johan.karlsteen@gmail.com> ---
(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


Mime
View raw message