https://bz.apache.org/bugzilla/show_bug.cgi?id=66433
Bug ID: 66433
Summary: [PATCH] Improve boolean functions empty cell handling
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 38467
--> https://bz.apache.org/bugzilla/attachment.cgi?id=38467&action=edit
boolean-blank-eval.patch
The attached patch fixes AND() and OR() when passing a function. Previously
BlankEvals have been ignored. Now they are treated as FALSE. This matches
Excels behavior (tested on Excel 2016).
This implementation works by mapping BlankEval to FALSE in class
BooleanFunction. This is my best guess at what Excel is doing behind the
scenes. But I am not sure as I didn't manage to come up with tests to
unambiguously differentiate the possibilities.
Anyways, I did add tests for this case, they match Excels behavior. All tests
are passing.
--
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]
