[Libreoffice-bugs] [Bug 118069] New: Adding multiple spanned cells causes addition error
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Fri Jun 8 12:46:32 UTC 2018
https://bugs.documentfoundation.org/show_bug.cgi?id=118069
Bug ID: 118069
Summary: Adding multiple spanned cells causes addition error
Product: LibreOffice
Version: 5.3.6.1 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs at lists.freedesktop.org
Reporter: howie at greenmuon.org
Description:
A spreadsheet has lots of numbers in many rows in one column. The next column
right adds up sequential ranges of rows to get a number. Another column to the
right of the second one adds up the second one's results to get further sums.
That third column starts producing incorrect results after the first few
additions.
Steps to Reproduce:
1. Load the attached "DiceRolling.ods" file in Calc.
2. Look at the additions being performed in cells F6, F9, F13, and F18
3. Compare the results of F9, F13, & F18 with what they should be (noted in
column G for those rows.)
Actual Results:
1+3+6 = 10 (that's OK)
1+3+6+10 = 26 (should be 20)
1+3+6+10+15 = 41 (should be 35)
1+3+6+10+15+21 = 62 (should be 56)
Expected Results:
See note above for actual versus correct results.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version 5.3.6.1
Build ID 5.3.6.1-10.el7
CPU Threads: 8; OS Version: Linux 3.10; UI Render: default; VCL: gtk3; Layout
Engine: new; Locale: en-AU (en_AU.UTF-8); Calc: group
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
Firefox/52.0
--
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/20180608/9f831d5b/attachment-0001.html>
More information about the Libreoffice-bugs
mailing list