Bug 119524

Summary:	Calc: SUM fails to give sum without any indication of the failure cause
Product:	LibreOffice	Reporter:	Kat <kittykat3756>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED INSUFFICIENTDATA
Severity:	normal	CC:	miguelangelrv
Priority:	medium
Version:	6.0.6.2 release
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	screenshot

Description Kat 2018-08-27 03:51:23 UTC

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

Comment 1 Kat 2018-08-27 04:21:00 UTC

Created attachment 144470 [details]
screenshot

Comment 2 m_a_riosv 2018-08-27 15:26:11 UTC

Please attach a sample file, the image doesn't help to test what happens.

Comment 3 Kat 2018-08-28 02:33:38 UTC

(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.

Comment 4 m_a_riosv 2018-08-28 08:20:05 UTC

Please if you have the issue again, reopen the bug and attach a sample file.