Bug 136590 - libreoffive calc
Summary: libreoffive calc
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.0.3 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-09-08 22:11 UTC by Yvan
Modified: 2020-09-22 11:39 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Yvan 2020-09-08 22:11:29 UTC
Description:
I have a problem with the multiplication with libreoffice calc bad result an exemple:  2.2*2.3=3.45


Actual Results:
i dontknow how to reproduce the bug it s basic operation

Expected Results:
good result



Reproducible: Sometimes


User Profile Reset: No



Additional Info:
wrong calcul
Comment 1 BogdanB 2020-09-09 05:48:20 UTC
I can NOT confirm this in
Version: 7.0.1.2
Build ID: 7cbcfc562f6eb6708b5ff7d7397325de9e764452
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-US (ro_RO.UTF-8); UI: en-US
Calc: threaded
Comment 2 BogdanB 2020-09-09 05:48:57 UTC
5.06 in my case

The formula is this: "=2.2*2.3"
Comment 3 BogdanB 2020-09-09 05:49:28 UTC
Go to Data - Calculate. Is the Autocalculate activated?
Comment 4 Xisco Faulí 2020-09-09 10:51:44 UTC
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. 
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
(Please note that the attachment will be public, remove any sensitive information before attaching it. 
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
Comment 5 BogdanB 2020-09-22 11:39:06 UTC
I discuss with Yvan in private, it's not a problem with LO, it's a number taht it's shown as "2 €", but in fact it is 1,996197 €.

So, when we multiply 2€ with 16, it's not 32. Because in fact 2 is not a 2. It's just with less decimal.