Bug 151011 - Simple subtraction fails with inaccurate result
Summary: Simple subtraction fails with inaccurate result
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.4.1.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-09-16 22:25 UTC by Aliain
Modified: 2022-09-17 12:09 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 Aliain 2022-09-16 22:25:41 UTC 
Description:
First installation of LibreOffice. Opened an ods sheet to find calculations wrong at sub-pico UNIT level. Tested number of calculations in case it was the file that was faulty.


Steps to Reproduce:
1.New CALC Sheet
2.In cell A1 enter 999.1
3.In cell B1 enter 999
4.In cell C1 enter =A1-B1
5.Set column C1 to optimum width OR Select cell C1 and view Average or Sum on bottom status bar

Actual Results:
Contents of cell C1 = 0.100000000000023

Expected Results:
Contents of cell C1 = 0.1


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
[Information automatically included from LibreOffice]
Locale: en-GB
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no

Version: 7.4.1.2 (x64) / LibreOffice Community
Build ID: 3c58a8f3a960df8bc8fd77b461821e42c061c5f0
CPU threads: 12; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: en-GB (en_GB); UI: en-GB
Calc: CL

New (first-time) installation. en-GB ver, Gaelic language additions, other languages deselected.