https://bugs.documentfoundation.org/show_bug.cgi?id=157803
Bug ID: 157803
Summary: Prevent extending decimal extension for calculations
with floating point arithmetic accuracy issues (IEEE
754) in 'General' number format type
Product: LibreOffice
Version: 7.6.2.1 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 190253
--> https://bugs.documentfoundation.org/attachment.cgi?id=190253&action=edit
Auto format hides rounding issue (IEEE 754) in Excel
To save frustration for users unfamiliar with rounding, a good improvement
would be to prevent the display of decimal digits from increasing for automatic
cell formatting.
This is how Excel works, and thanks to this simple trick, in over a dozen years
of use, I have never worried about strange values appearing in the formula bar.
The values in the cells did not diverge and the sheet looked legible and that
was enough for me.
Since I use Calc, this behavior of the program prompted me to report a bug. But
ultimately it turns out that this is the nature of digital binary computing.
References:
https://bugs.documentfoundation.org/show_bug.cgi?id=128312#c9
https://bugs.documentfoundation.org/show_bug.cgi?id=156858
https://bugs.documentfoundation.org/show_bug.cgi?id=129606
--
You are receiving this mail because:
You are the assignee for the bug.
