[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 14:48:44 UTC 2021
https://bugs.documentfoundation.org/show_bug.cgi?id=141292
--- Comment #25 from steffan.steffner at gmx.net ---
As a draft / proposal for this tooltip:
- tooltip would be shown when doing a mouse-over on the cell of the spreadsheet
where the result would be different
- the text in the tooltip would be:
“Note: Since Calc is internally calculating with more digits than you selected
to display in your spreadsheet, the result at hand would here be different when
using the numbers as displayed. The cells causing this are ……..
See also here
https://help.libreoffice.org/7.1/en-US/text/scalc/guide/rounding_numbers.html
- Sure enough, the text would need to be truncated, and only when the user
clicks on it he/she can see all of it
- for not annoying the user, the tooltip would fade out after 2 seconds, if
he/she has not clicked on the text; only if the cursor is moved away for a
longer time, and then a mouse-over on the cell is done again, will the tooltip
re-appear
In case somebody doubts whether many more people except me have run into this
problem, you can do a g**gle search for e.g.
libreoffice calc summe falsch Genauigkeit wie angezeigt
or
libreoffice calc sum wrong precision as shown
--
You are receiving this mail because:
You are on the CC list for the bug.
More information about the Libreoffice-ux-advise
mailing list