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

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #23 from Mike Kaganski <mikekaganski at hotmail.com> ---
Created attachment 171117
  --> https://bugs.documentfoundation.org/attachment.cgi?id=171117&action=edit
"Set precision as displayed" in Excel 2016

(In reply to Heiko Tietze from comment #22)
> 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.

Note also that it would need to calculate everything twice, to know if a value
actually shown would differ from value that would be shown in case of
"precision as shown". It would be a considerable (x2!) performance penalty of
an "innocent option".

> 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.

At least Excel 2016 also buries it in some advanced section, and does not show
it in its "Tell me ..." search results.

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