<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - Calc should display hint "internal calculation is done without rounding"." href="https://bugs.documentfoundation.org/show_bug.cgi?id=141292#c23">Comment # 23</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - Calc should display hint "internal calculation is done without rounding"." href="https://bugs.documentfoundation.org/show_bug.cgi?id=141292">bug 141292</a> from <a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> Mike Kaganski</a> <pre>Created <a href="https://bugs.documentfoundation.org/attachment.cgi?id=171117" name="attach_171117" title=""Set precision as displayed" in Excel 2016">attachment 171117</a> <a href="https://bugs.documentfoundation.org/attachment.cgi?id=171117&action=edit" title=""Set precision as displayed" in Excel 2016">[details]</a> "Set precision as displayed" in Excel 2016 (In reply to Heiko Tietze from <a href="show_bug.cgi?id=141292#c22">comment #22</a>) > 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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>