https://bz.apache.org/bugzilla/show_bug.cgi?id=69341
Bug ID: 69341
Summary: Formula: =PRODUCT(A1:A2) with True, True falsely
evaluates to 0
Product: POI
Version: unspecified
Hardware: PC
OS: Linux
Status: NEW
Severity: trivial
Priority: P2
Component: XSSF
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
The formula =PRODUCT(A1:A2) with A1=TRUE() and A2=TRUE() evaluates (with
formula evaluation) to 0; Expected result (Libre Office Calc) is 1.
=PRODUCT(TRUE();TRUE()) evaluates to 1.
(And(A1:A2) works. Finding this just annoyed me to no end.)
--
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]
