[Upstream] Libreoffice Calc's PRODUCT function doesn't calculate correctly with certain array formulas
Bug #775608 reported by
F.H.
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
LibreOffice |
Fix Released
|
Critical
|
|||
libreoffice (Ubuntu) |
Fix Released
|
High
|
Björn Michaelsen | ||
Natty |
Fix Released
|
High
|
Unassigned |
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(
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]
description: | updated |
Changed in libreoffice (Ubuntu): | |
assignee: | nobody → Björn Michaelsen (bjoern-michaelsen) |
Changed in df-libreoffice: | |
importance: | Unknown → Critical |
status: | Unknown → Fix Released |
Changed in libreoffice (Ubuntu): | |
importance: | Undecided → Critical |
Changed in libreoffice (Ubuntu Natty): | |
importance: | Undecided → High |
Changed in libreoffice (Ubuntu): | |
importance: | Critical → High |
tags: |
added: verification-done removed: verification-needed |
Changed in df-libreoffice: | |
status: | Fix Released → Confirmed |
Changed in df-libreoffice: | |
status: | Confirmed → Fix Released |
To post a comment you must log in.
ADDENDUM: Interestingly, this calculation error appears to be a problem only with the PRODUCT function in LibreOffice Calc. For instance, if in the above array formula you substitute PRODUCT with, say, SUM, both OpenOffice and LibreOffice Calc display the correct result, 2.6. Hope this is helpful.