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: [email protected]
Reporter: [email protected]
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: [email protected]
For additional commands, e-mail: [email protected]
