https://issues.apache.org/bugzilla/show_bug.cgi?id=52063
Bug #: 52063
Summary: Implement LOOKUP(lookup_value,array)
Product: POI
Version: 3.8-dev
Platform: PC
Status: NEW
Severity: enhancement
Priority: P2
Component: HSSF
AssignedTo: dev@poi.apache.org
ReportedBy: marcel.may...@gmail.com
CC: marcel.may...@gmail.com
Classification: Unclassified
Excel-Sheets containing LOOKUP(lookup_value,array) formula fail since its not
yet implemented:
java.lang.RuntimeException: Two arg version of LOOKUP not supported yet
at org.apache.poi.ss.formula.functions.Lookup.evaluate(Lookup.java:44)
at
org.apache.poi.ss.formula.functions.Var2or3ArgFunction.evaluate(Var2or3ArgFunction.java:34)
at
org.apache.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:132)
at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:460)
at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:283)
at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:225)
at
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateFormulaCellValue(HSSFFormulaEvaluator.java:354)
at
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluate(HSSFFormulaEvaluator.java:185)
I'll try to provide a test case and an implementation.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
