Bug 161682

Summary:	Incorrect Calculation Results
Product:	LibreOffice	Reporter:	Human <tedasal758>
Component:	deletionRequest	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED INVALID
Severity:	normal	CC:	rb.henschel, stephane.guillou
Priority:	medium
Version:	6.4.5.2 release
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:

Description Human 2024-06-20 04:36:59 UTC

Description:
The SUM function in LibreOffice Calc is producing incorrect results under specific conditions. This issue affects the accuracy of calculations within spreadsheets, potentially impacting data integrity and usability.

Steps to Reproduce:
1.Open LibreOffice Calc 
2.Create a new spreadsheet
3.Enter numerical values in cells A1 to A5
4.In cell A6, enter the formula =SUM(A1:A5)
5.Expected result: The sum displayed in cell A6 should be 150 (i.e., 10 + 20 + 30 + 40 + 50).


Actual Results:
The sum displayed in cell A6 is incorrect result, which does not match the expected total

Expected Results:
The SUM function should accurately calculate and display the sum of the specified range of cells without errors or discrepancies.


Reproducible: Always


User Profile Reset: No

Additional Info:
This issue occurs consistently regardless of the values or ranges used.
The problem persists after restarting LibreOffice Calc and the computer.
Screenshots and sample spreadsheet demonstrating the issue are attached.

Comment 1 Regina Henschel 2024-06-20 14:43:08 UTC

Please attach a document, that shows the problem.

Please add which version you use. You find this information in Help > About.

Comment 2 Stéphane Guillou (stragu) 2024-06-21 14:13:19 UTC

likely part of the recent spam wave. (old version, says documents are attached but there's nothing...)