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
Created attachment 142617 [details] Spreadsheet file that produces the problem, screen snaps, & system info.
Did find the problem In D5 there is formula and in D6 the number 6 when merging this together you see only the sum formula, split the cell's D5 and D6 and you will see the error So not a bug its a WFM If you not agree you can reopen it as unconfirmed
Sorry to have wasted your time with my oversight. Is there any way to set Calc to flag hidden values? I never knew it could do that, so I assumed that what I was seeing was real and complete. Regards, Howard
No problem, we are here to help so don't be sorry. regards Xavier
If you want a warning when merging two cells you need to upgrade your LO to version 5.4.6.2 or 6.0.4.2 and daily builds. With these versions there is a warning and a choice to delete the second entry when merging two cells. regards Xavier