https://bugs.documentfoundation.org/show_bug.cgi?id=163895
Bug ID: 163895
Summary: UI: FILESAVE: falsifying values, inconsistency after
save and reload,
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
If you enter a value with more than 15 digits, e.g.
0.9999999999999994, it is shown in formulas abbreviated to 15 digits,
0.999999999999999, but the trailing 4 is accounted in calculations, e.g.
multiplying that value with 6 leads to '6'.
( Small differences like that are mostly covered by shortened display and
'approximate equality' and the like, to get detailed info use 'rawsubtract'. )
In a save - close - load cycle the trailing 4 is lost, and the calculation 6
times the new value results in 5.99999999999999.
That leads to different behavior / results between sheet construction and later
use, which should - IMHO - be unwanted.
Steps to Reproduce:
see description
Actual Results:
different behavior between input and loaded file.
Expected Results:
coherent behavior, either truncate / falsify / round values on input, or keep
precision in save - load.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 24.2.5.2 (X86_64) / LibreOffice Community
Build ID: 420(Build:2)
CPU threads: 8; OS: Linux 6.8; UI render: default; VCL: x11
Locale: en-US (en_US.UTF-8); UI: en-US
Debian package version: 4:24.2.5-4
Calc: threaded
happened with older versions too.
--
You are receiving this mail because:
You are the assignee for the bug.
