Public bug reported:
Binary package hint: libreoffice
The best way to explain this bug is with a simple example. Type the
values 0.1, 0.2, and 0.3 in cells A1, A2, and A3; then on cell C1 type
"=PRODUCT(1+A1:A3)-1" without the quotes; and then press
<Control><Enter>. (If you do this correctly, cell C1 will display the
formula in curly brackets, i.e., "{=PRODUCT(1+A1:A3)-1}", signifying
that C1 contains an array formula.)
If you do this in OpenOffice Calc, cell C1 displays the correct result,
0.716 -- the product of (1+0.1) times (1+0.2) times (1+0.3), less 1. If
you do this in LibreOffice Calc, cell C1 displays 0 !!!
** Affects: libreoffice (Ubuntu)
Importance: Undecided
Status: New
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/775608
Title:
Libreoffice Calc's PRODUCT function doesn't calculate correctly with
certain array formulas
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
