https://bugs.freedesktop.org/show_bug.cgi?id=76663
Priority: medium
Bug ID: 76663
Assignee: [email protected]
Summary: LibreOffice Calc's PRODUCT function returns incorrect
results in array formula
Severity: major
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.0.6.2 release
Component: Spreadsheet
Product: LibreOffice
Example: enter following in cells A1:A4: 0.1, 0.2, 0.3, 0.4. In cell C1 enter
following array function: {=PRODUCT(1+A1:A4)-1}. Correct answer is 1.4024 =
((1.1)*(1.2)*(1.3)*(1.4))-1. LibreOffice Calc ver. 4.0.6.2 returns answer of
1.1840, which is equivalent to {=PRODUCT(1+A2:A4)-1} or ((1.2)*(1.3)*(1.4))-1.
LibreOffice Calc is performing the computation, but ignoring the first number
in cell A1. The error is not obvious on its face and might not be detected. The
consequences could be devastating for users relying on LibreOffice to perform
critical work.
--
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
