https://bugs.documentfoundation.org/show_bug.cgi?id=120560
Bug ID: 120560
Summary: Calc Spreadsheet arithmetic error depending on cell
width
Product: LibreOffice
Version: 6.1.2.1 release
Hardware: Other
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I installed version 6.1.2.1 on a Windows 8.1 Toshiba laptop. The error occurs
when the cell width exceeds 1.25".
In a wide cell, I typed:
=267.52-266.54
The result is:
0.979999999999961
I get the same result when I put the values in two cells, and do the
subtraction by reference.
Steps to Reproduce:
1. set cell width to exceed 1.25"
2. type: =267.52-266.54
3. hit <ENTER>
Actual Results:
0.979999999999961
Expected Results:
0.98
Reproducible: Always
User Profile Reset: No
Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: StartModule
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no
===================
Version: 6.1.2.1 (x64)
Build ID: 65905a128db06ba48db947242809d14d3f9a93fe
CPU threads: 4; OS: Windows 6.3; UI render: default;
Locale: en-US (en_US); Calc: group threaded
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs