Description: The SUM function works on some rows in the document and not on others, I cannot find the reason for it not working (row formatting is identical as far as I can see and I've tried copy/pasting the formatting). There is no other indication for why it may not be working that I can see. In the end, I fixed it by copy/pasting the content of the working SUM cell in the H column into one that was broken. When I tried to undo the copy/paste, it still kept working after the change was undone. Steps to Reproduce: Not sure how I triggered the bug. I copy pasted the first row with the calculation into all the subsequent rows and filled in the numbers for adding up manually. First few rows add up correctly, but later ones do not. (See screenshot.) I have tried applying the formatting from the working rows to the broken rows with no change. Actual Results: SUM of D31:G31 shown as £700.00 in H31 (see screenshot) Expected Results: SUM of D31:G31 shown as £858.10 in H31 (see screenshot) Reproducible: Couldn't Reproduce User Profile Reset: No Additional Info: Version: 6.0.6.2 Build ID: 6.0.6-1 CPU threads: 4; OS: Linux 4.17; UI render: default; VCL: gtk3; Locale: en-GB (en_GB.UTF-8); Calc: group
Created attachment 144470 [details] screenshot
Please attach a sample file, the image doesn't help to test what happens.
(In reply to m.a.riosv from comment #2) > Please attach a sample file, the image doesn't help to test what happens. As I said in the original bug description, I fixed the problem by copy/pasting the SUM function from a working cell to the not-working cell (the broken cell had afaik identical content in the broken and working states). After it was fixed, I could not return to the broken state even by undoing the fix. If you think it would still be helpful to see the now problem-free file, I can attach it, but I will have to strip most of the content out because it contains private/sensitive information.
Please if you have the issue again, reopen the bug and attach a sample file.