poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 51024] New: VLOOKUP/HLOOKUP default behaviour
Date Tue, 05 Apr 2011 16:06:36 GMT
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


Mime
View raw message