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

           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


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

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

View raw message