2011-05-02 14:12:28 |
F.H. |
bug |
|
|
added bug |
2011-05-02 15:07:16 |
F.H. |
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><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 !!! |
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] |
|
2011-05-02 16:21:22 |
Björn Michaelsen |
bug task added |
|
df-libreoffice |
|
2011-05-02 16:21:40 |
Björn Michaelsen |
summary |
Libreoffice Calc's PRODUCT function doesn't calculate correctly with certain array formulas |
[Upstream] Libreoffice Calc's PRODUCT function doesn't calculate correctly with certain array formulas |
|
2011-05-02 16:21:51 |
Björn Michaelsen |
df-libreoffice: status |
New |
Confirmed |
|
2011-05-02 16:21:54 |
Björn Michaelsen |
libreoffice (Ubuntu): status |
New |
Confirmed |
|
2011-05-03 18:00:37 |
Björn Michaelsen |
bug watch added |
|
http://bugs.freedesktop.org/show_bug.cgi?id=36810 |
|
2011-05-03 18:00:37 |
Björn Michaelsen |
df-libreoffice: importance |
Undecided |
Unknown |
|
2011-05-03 18:00:37 |
Björn Michaelsen |
df-libreoffice: status |
Confirmed |
Unknown |
|
2011-05-03 18:00:37 |
Björn Michaelsen |
df-libreoffice: remote watch |
|
freedesktop.org Bugzilla #36810 |
|
2011-05-03 18:16:46 |
Björn Michaelsen |
libreoffice (Ubuntu): assignee |
|
Björn Michaelsen (bjoern-michaelsen) |
|
2011-05-03 18:22:43 |
Bug Watch Updater |
df-libreoffice: status |
Unknown |
Fix Released |
|
2011-05-03 18:22:43 |
Bug Watch Updater |
df-libreoffice: importance |
Unknown |
Critical |
|
2011-05-03 20:11:54 |
Björn Michaelsen |
attachment added |
|
proposed fix against the sc repo of on tag 3.3.2.2 https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/775608/+attachment/2110308/+files/lp775608.diff |
|
2011-05-03 20:12:14 |
Björn Michaelsen |
libreoffice (Ubuntu): status |
Confirmed |
In Progress |
|
2011-05-03 22:16:48 |
Björn Michaelsen |
libreoffice (Ubuntu): status |
In Progress |
Fix Committed |
|
2011-05-04 07:32:08 |
Martin Pitt |
nominated for series |
|
Ubuntu Natty |
|
2011-05-04 07:32:08 |
Martin Pitt |
bug task added |
|
libreoffice (Ubuntu Natty) |
|
2011-05-04 09:11:26 |
Björn Michaelsen |
attachment added |
|
joined debdiff for lp#775608 and lp#746375 https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/775608/+attachment/2111415/+files/lp775608-deb.diff |
|
2011-05-04 09:45:19 |
Martin Pitt |
libreoffice (Ubuntu): importance |
Undecided |
Critical |
|
2011-05-04 09:45:22 |
Martin Pitt |
libreoffice (Ubuntu Natty): importance |
Undecided |
High |
|
2011-05-04 09:45:24 |
Martin Pitt |
libreoffice (Ubuntu): importance |
Critical |
High |
|
2011-05-04 09:49:00 |
Björn Michaelsen |
bug |
|
|
added subscriber Björn Michaelsen |
2011-05-04 09:49:36 |
Björn Michaelsen |
bug |
|
|
added subscriber Ubuntu Stable Release Updates Team |
2011-05-05 05:11:58 |
Martin Pitt |
libreoffice (Ubuntu Natty): status |
New |
Fix Committed |
|
2011-05-05 05:12:00 |
Martin Pitt |
bug |
|
|
added subscriber SRU Verification |
2011-05-05 05:12:03 |
Martin Pitt |
tags |
|
verification-needed |
|
2011-05-05 12:06:16 |
Jean-Baptiste Lallement |
tags |
verification-needed |
verification-done |
|
2011-05-17 07:31:37 |
Launchpad Janitor |
libreoffice (Ubuntu Natty): status |
Fix Committed |
Fix Released |
|
2011-05-17 07:32:20 |
Martin Pitt |
libreoffice (Ubuntu): status |
Fix Committed |
Fix Released |
|
2013-02-20 09:35:30 |
Bug Watch Updater |
df-libreoffice: status |
Fix Released |
Confirmed |
|
2013-11-17 12:16:06 |
Bug Watch Updater |
df-libreoffice: status |
Confirmed |
Fix Released |
|