https://bugs.freedesktop.org/show_bug.cgi?id=42481
Bug #: 42481
Summary: Incorrect SUMPRODUCT result
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.3.4 release
Platform: x86 (IA32)
OS/Version: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
A1:A4 has x,1,2,3
B1:B4 has y,1,2,3
C1:C4 has =A1*B1,...,=A4*B4 (which shows as #VALUE!,1,4,9)
E6 has =SUMPRODUCT(A1:A4*B1:B4)
E7 has =SUMPRODUCT(C1:C4)
E6 and E7 should show the same value since the result of A1:A4*B1:B4 is the
same as C1:C4 (you could also enter the result of A1:A4*B1:B4 as an array in
C1:C4 and observe the same).
The correct value for these SUMPRODUCT values is #VALUE! since ODF/OPENFORMULA
(ODF 1.2, part 2, 6.1) requires SUMPRODUCT to return an error when a value
provided to it is an error.
E6 incorrectly shows 14.
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
