Bug 157803

Summary:	Prevent extending decimal extension for calculations with floating point arithmetic accuracy issues (IEEE 754) in 'General' number format type
Product:	LibreOffice	Reporter:	Piotr Osada <piotr.osada>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	UNCONFIRMED ---
Severity:	enhancement
Priority:	medium
Version:	7.6.2.1 release
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	Auto format hides rounding issue (IEEE 754) in Excel

Description Piotr Osada 2023-10-17 09:29:13 UTC

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

Comment 1 Eyal Rozenberg 2023-11-14 21:28:28 UTC

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.