https://bugs.documentfoundation.org/show_bug.cgi?id=162883
Bug ID: 162883
Summary: Difference between cells with different contents is 0
Product: LibreOffice
Version: 3.3.0 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
The difference between the values 0,0555555555555555 and 0,0555555555555556 is
even in scientific format displayed as 0,00E+00.
The real version was not selectable, so I selected 3.3.0 release, see below
Steps to Reproduce:
Enter values (with sufficiently large column width):
Cell A1: 0,0555555555555555
Cell A2: 0,0555555555555556
Enter formula:
Cell A3: =A2-A1
Change format in Cell A3 to scientific format 0,00E+00
see result
Actual Results:
0,00+00 in Cell A3
Expected Results:
1,00-16
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 24.2.5.2 (X86_64) / LibreOffice Community
Build ID: bffef4ea93e59bebbeaf7f431bb02b1a39ee8a59
CPU threads: 8; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
