** Changed in: df-libreoffice
Status: Confirmed => Fix Released
--
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/775608
Title:
[Upstream] Libreoffice Calc's PRODUCT function doesn't calculate
correctly with certain array formulas
Status in LibreOffice Productivity Suite:
Fix Released
Status in “libreoffice” package in Ubuntu:
Fix Released
Status in “libreoffice” source package in Natty:
Fix Released
Bug description:
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><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]
To manage notifications about this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug/775608/+subscriptions
--
Mailing list: https://launchpad.net/~desktop-packages
Post to : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help : https://help.launchpad.net/ListHelp
