[Libreoffice-ux-advise] [Bug 141292] Calc should display hint "internal calculation is done without rounding".

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Mon Apr 12 08:08:14 UTC 2021


https://bugs.documentfoundation.org/show_bug.cgi?id=141292

--- Comment #22 from Heiko Tietze <heiko.tietze at documentfoundation.org> ---
"Precision as shown" is fooling you ;-). 1.01+1.01 is 2.02 but if you calculate
without decimal places you get 2. This option is generic and applies to all
value in the sheet. 

You expect highlighting of (calculated only?) cells with 1.0101 but not 1.0100
(given only two decimal points are shown). To not clutter the UI it needs to be
an option, for example somehow combined with View > Value Highlighting perhaps
with a brighter or darker color.

Do you think average users not being aware of the danger that "Precision as
shown" switch on this option and understand the outcome?

Seems to me "Precision as shown" is a dangerous option and we need to hide it
(what's the use case of it anyway) or at least put it into some expert section.

-- 
You are receiving this mail because:
You are on the CC list for the bug.


More information about the Libreoffice-ux-advise mailing list