Created attachment 190253 [details] 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
Please... 1. Attach an ODS file with the example in the screenshot. 2. Be more specific: Characterize how precision increases today, and what precision increase logic you're proposing. 3. Explain the relation to the other bugs you linked to.