https://issues.apache.org/bugzilla/show_bug.cgi?id=51024
Summary: VLOOKUP/HLOOKUP default behaviour
Product: POI
Version: unspecified
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: minor
Priority: P2
Component: POI Overall
AssignedTo: dev@poi.apache.org
ReportedBy: thomas.themel@mirai-solutions.com
Hi,
There seems to be a problem with "empty" arguments in Excel formulae, at least
for VLOOKUP and HLOOKUP. Excel accepts formulae of the form
"=VLOOKUP(B2;B5:C7;2;)" as equivalent to "=VLOOKUP(B2;B5:C6;2)", but POI fails
to evaluate this field with "Unexpected eval type
(org.apache.poi.ss.formula.eval.MissingArgEval)".
Probably Var3or4ArgFunction and its cousins should check for the last argument
to be of type MissingArgEval as well?
--
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-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
|