** Description changed:
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.)
+ <Control><Shift><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 !!!
+
+ [EDITED TO CORRECT TYPO]
--
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
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
