Bug 154791

Summary:	Calculation incorrect
Product:	LibreOffice	Reporter:	JP Kakebeeke <jpkakebeeke>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED INVALID
Severity:	normal	CC:	raal
Priority:	medium
Version:	7.3.7.2 release
Hardware:	x86-64 (AMD64)
OS:	Linux (All)
Whiteboard:
Crash report or crash signature:		Regression By:

Description JP Kakebeeke 2023-04-13 16:52:38 UTC

Description:
In a spreadsheet I have the following.


The correct answer should be 115,389.50

Steps to Reproduce:
B6 = 50
E6 = 2307.97
G6 = Sum(B6*E6)


Actual Results:
The answer that is displayed 115,398.50

Expected Results:
The correct answer should be 115,389.50


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 7.3.7.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 4; OS: Linux 5.19; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Ubuntu package version: 1:7.3.7-0ubuntu0.22.04.2
Calc: threaded

Comment 1 raal 2023-04-13 18:03:23 UTC

50×2307,97 = 115398,5

Why should the result be different?

Comment 2 JP Kakebeeke 2023-04-14 10:33:13 UTC

I am very sorry - DISLEXIA on my side.
The figure that I used should have been 2307.79 and Not as stated 2307.97
That is where the F.up came in.
Yes I have accepted the ID10T of the day award.
Sorry for wasting your time. :-(

Comment 3 raal 2023-04-14 11:40:17 UTC

No problem :), closing the bug.