Bug 154791 - Calculation incorrect
Summary: Calculation incorrect
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.7.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-04-13 16:52 UTC by JP Kakebeeke
Modified: 2023-04-14 13:37 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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.