[Libreoffice-bugs] [Bug 118069] New: Adding multiple spanned cells causes addition error

[bugzilla-daemon at bugs.documentfoundation.org]

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>