[Libreoffice-bugs] [Bug 135103] Decimal precision fail in addition

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #3 from Mike Kaganski <mikekaganski at hotmail.com> ---
(In reply to Michael Warner from comment #2)
> That said, one could argue that it would be more user friendly if
> the formatting of a cell containing an equation (and the sum in the corner)
> defaulted to the number of decimal places shown to the minimum (or maximum)
> number of decimal places entered in any referenced cell containing a number.
> In the example provided, it just doesn't make sense to display a result to
> 14 places when at most 2 are provided.

That is over-simplification. So for this formula:

> = <cell with 1> + <cell with 10> ^ <cell with -5>

all cells are shown with default formatting; all are whole numbers. Are you
telling we need to show "1" instead of "1.00001"?

It's very difficult to come with a reasonable default precision (and analyzing
the formula, taking into account display format, with its optional digits "#",
display of multiples of 1000, scientific notation, percents, etc, may be very
expensive and error-prone); IIRC Eike ~recently changed the default to "show as
many as fit in column", but I may be wrong.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200725/b0ac2275/attachment-0001.htm>