[Libreoffice-bugs] [Bug 122524] New: EDITING :: Wrong calculation results, depends on the order of items
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Mon Jan 7 08:29:15 UTC 2019
https://bugs.documentfoundation.org/show_bug.cgi?id=122524
Bug ID: 122524
Summary: EDITING :: Wrong calculation results, depends on the
order of items
Product: LibreOffice
Version: 6.1.4.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs at lists.freedesktop.org
Reporter: eko at lanet.lv
Created attachment 148086
--> https://bugs.documentfoundation.org/attachment.cgi?id=148086&action=edit
The Calc spreadsheet with the given example
The following equation gives a wrong result:
100 - 1.4 - 95.9 - 2.7 = -1,15463194561016E-14
Should be: 0
If the item order is changed, the calculated result is correct:
100 - 95,9 - 1,4 - 2,7 = 0.
The tested versions:
Fedora 23 / LibreOffice 5.3.2.1 30(Build:1) x64
Fedora 28 / LibreOffice 6.0.7.3.0 00(Build:3) x64
Windows 10 / LibreOffice 6.1.4.2 (Build ID:
9d0f32d1f0b509096fd65e0d4bec26ddd1938fd3) x64
--
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190107/7452313f/attachment-0001.html>
More information about the Libreoffice-bugs
mailing list