https://bz.apache.org/bugzilla/show_bug.cgi?id=63984
Bug ID: 63984
Summary: [PATCH] AND / OR should treat missing parameters as
FALSE
Product: POI
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: P2
Component: SS Common
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Created attachment 36909
--> https://bz.apache.org/bugzilla/attachment.cgi?id=36909&action=edit
bool_missing_params.patch
`=AND(TRUE,)` returns TRUE in POI, but FALSE in Excel 2003 and Excel 2013.
It seems that Excel treats the missing parameter as FALSE. POI on the other
hand ignores the missing parameter.
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]
