Bug 131482 - Wrong calculation result in merged cell
Summary: Wrong calculation result in merged cell
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
6.0.7.3 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-03-22 17:41 UTC by BravPyth
Modified: 2020-03-30 12:54 UTC (History)
2 users (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 BravPyth 2020-03-22 17:41:37 UTC 
Description:
In cell A1 : 2481,8
In cell A3 : 2426,96
In merged cell B1, B2, B3  =A1-A3 
The result is wrong

Steps to Reproduce:
1.2481,8 in A1
2.2426,96 in A3
3.=A1-A3 in (B1+B2+B3) (cellules fusionnées)

Actual Results:
54,8400000000001 

Expected Results:
54,84


Reproducible: Always


User Profile Reset: No



Additional Info:
repetitive error
Comment 1 Xisco Faulí 2020-03-23 13:21:47 UTC 
Thank you for reporting the bug.
it seems you're using an old version of LibreOffice.
Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ?
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.
Comment 2 BravPyth 2020-03-23 17:51:07 UTC 
Thank you for your answer. I can neither confirm nor deny since I am having some problems installing the new version. Since everything is written in English and I use google to translate, I need a little time.
Comment 3 QA Administrators 2020-03-24 02:48:53 UTC Comment hidden (obsolete)
Comment 4 Kevin Suo 2020-03-25 15:34:44 UTC 
(In reply to BravPyth from comment #2)
Could you please copy-paste the information on "About > LibreOffice" dialog? I do not reproduce with either 6.3.5.2 or the latest master.
Comment 5 BravPyth 2020-03-25 16:24:18 UTC 
Version: 6.0.7.3
Build ID: 1:6.0.7-0ubuntu0.18.04.10
Threads CPU : 4; OS : Linux 4.15; UI Render : par défaut; VCL: gtk3; 
Locale : fr-FR (fr_FR.UTF-8); Calc: group

My version is an earlier version. And for the moment, I have not managed to install a newer version. (Google traduction)
Comment 6 Kevin Suo 2020-03-30 00:15:27 UTC 
(In reply to BravPyth from comment #5)

Thinks for testing.

In case it works in a new version and we don't know which commit fixed this, then the correnct status should be RESOLVED WORKSFORME.
Comment 7 BravPyth 2020-03-30 12:54:21 UTC 
OK merci !