https://bugs.documentfoundation.org/show_bug.cgi?id=141292
--- Comment #23 from Mike Kaganski <mikekagan...@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 the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs