Bug 144170

Summary:	the sum function does not work properly when adding additional numbers.
Product:	LibreOffice	Reporter:	Nath <nbkaplan>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED NOTABUG
Severity:	minor
Priority:	low
Version:	7.2.0.4 release
Hardware:	All
OS:	All
See Also:	https://bugs.documentfoundation.org/show_bug.cgi?id=149041
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	screen shot of the Sum issue

Description Nath 2021-08-30 00:49:59 UTC

Description:
If you use the Sum function to total numbers then you add additional numbers below the total sum number and then try to sum those numbers the system will not total those numbers.  example 1+1 sum gives you 2. if I add 1 and try to sum the 2 and 1 the systems Sum is 1.
This has happened in the last few releases.  


Steps to Reproduce:
1. List two numbers
2. Sum that list with the Sum icon on the toolbar. 
3. Add another number below the sum and try to use the sum icon again it will not sum out the two numbers.  the system will give you the added number as the total

Actual Results:
the system ignores the total numbers and only gives you the added numbers
Ex. 1+1 Sum is 2, Add 1 and Sum the 2 and 1 the system will give you 1.

Expected Results:
When you take 1+1 and the sum is 2, if I add 1 and Sum the 2&1 you should get 3 but you get 1.


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
none

Comment 1 Nath 2021-08-30 00:52:20 UTC

Created attachment 174620 [details]
screen shot of the Sum issue

Comment 2 [REDACTED] 2021-08-30 10:23:16 UTC

(In reply to Nath from comment #0)
> Description:

> This has happened in the last few releases.  
> 

It works since "LibreOffice 3.3.0 OOO330m19 (Build:6)tag libreoffice-3.3.0.4" this way. Autosum sums all values above "until" there is another "SUM()"  formula. 

From my perspective not a bug.

Comment 3 [REDACTED] 2021-08-30 11:46:20 UTC

See also LibreOffice Help - Select Function (https://help.libreoffice.org/latest/en-US/text/scalc/02/06030000.html?DbPAR=CALC#bm_id3157909) stating:

Select Function applied with no selected range

LibreOffice automatically suggests a cell range, provided that the spreadsheet contains data. If the cell range already contains a function, you can combine it with the new one to yield the function applied to the range data. [snip]

The phrase "you can combine" means: You can expand the suggested range to include the cell(s) having formulas by using the blue square handles at any corner of the suggested range.

Comment 4 Nath 2021-08-31 02:10:03 UTC

thank you for your response.  I tested your response and it does work but it requires an extra step so I still think the system is not working properly.
If I select the row with the Sum and then select the next row with the additional number and go to a blank cell and use the Sum function it does not return the sum.  Based on your response, I now have to highlight the sum cell and include the other sum number.  I think that is a silly extra step.   I know this is no Excel but that is not how it works in excel.  I should be able to select a row of numbers and get a sum without having to do the extra step of going back to include a cell.
Thank you.

Comment 5 [REDACTED] 2021-09-01 08:55:17 UTC

(In reply to Nath from comment #4)

> .... the system is not working properly.

It is documented behavior (as stated in my previous comment #3 and as such not a bug in the sense of a failing functionality. I will leave it to others to decide whether your request is at least an enhancement request.

Comment 6 Timur 2022-05-13 10:32:10 UTC

This is not a bug. 
Question is: should it be an enhancement? I don't think so. You will rarely have this example, contiguous numbers adding to different sums. Marking NAB.
Excel also works like LO and not like in this request.