You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2019/12/03 10:35:37 UTC
[Bug 63984] New: [PATCH] AND / OR should treat missing parameters as
FALSE
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: dev@poi.apache.org
Reporter: patrick.boeker@haltec.de
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 63984] [PATCH] AND / OR should treat missing parameters as
FALSE
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63984
Patrick Böker <pa...@haltec.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords| |PatchAvailable
--
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
[Bug 63984] [PATCH] AND / OR should treat missing parameters as
FALSE
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63984
--- Comment #1 from Patrick Böker <pa...@haltec.de> ---
Created attachment 36910
--> https://bz.apache.org/bugzilla/attachment.cgi?id=36910&action=edit
BooleanFunctionsTestCaseData.xls
To be placed in test-data\spreadsheet\BooleanFunctionsTestCaseData.xls
--
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
[Bug 63984] [PATCH] AND / OR should treat missing parameters as
FALSE
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63984
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |FIXED
Status|NEW |RESOLVED
--- Comment #2 from Dominik Stadler <do...@gmx.at> ---
Applied via r1872125, thanks for the patch!
--
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