[Bug 64238] New: [PATCH] Make LOOKUP functions deal with empty last arg correctly

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

[Bug 64238] New: [PATCH] Make LOOKUP functions deal with empty last arg correctly

Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=64238

            Bug ID: 64238
           Summary: [PATCH] Make LOOKUP functions  deal with empty last
                    arg correctly
           Product: POI
           Version: unspecified
          Hardware: All
                OS: All
            Status: NEW
          Severity: minor
          Priority: P2
         Component: SS Common
          Assignee: [hidden email]
          Reporter: [hidden email]
  Target Milestone: ---

Created attachment 37103
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=37103&action=edit
lookup_missing_param.patch

In `=VLOOKUP(A1,A2:C3,2,)` the last arg was seen as TRUE in POI, but FALSE in
Excel 2003 and Excel 2013.

This patch makes POI behave like Excel in this regard.
I have added some tests to verify the bahvior.

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 64238] [PATCH] Make LOOKUP functions deal with empty last arg correctly

Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=64238

--- Comment #1 from Patrick Böker <[hidden email]> ---
Created attachment 37104
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=37104&action=edit
LookupFunctionsTestCaseData.xls

To be placed in test-data\spreadsheet\LookupFunctionsTestCaseData.xls

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 64238] [PATCH] Make LOOKUP functions deal with empty last arg correctly

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=64238

Patrick Böker <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Keywords|                            |PatchAvailable

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]