https://bugs.documentfoundation.org/show_bug.cgi?id=151011
Bug ID: 151011
Summary: Simple subtraction fails with wrong result
Product: LibreOffice
Version: 7.4.1.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: h31...@gmail.com
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.
--
You are receiving this mail because:
You are the assignee for the bug.
