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

Eike Rathke <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Assignee|[email protected]            |[email protected]
                   |                            |desktop.org

--- Comment #24 from Eike Rathke <[email protected]> ---
We do not state a precision higher than 12 significant decimal digits.
In fact this is on purpose here, see the change's source code comment:

// A quite aggressive approach with 12 significant digits.
// However, using 14 or some other doesn't work because other
// values may fail, like =ROUNDDOWN(2-5E-015;13) would produce
// 2 (another example in tdf#124286).

If Excel does not exhibit a round-off _in this case_ then fine for Excel.
Otherwise see
https://en.wikipedia.org/wiki/Numeric_precision_in_Microsoft_Excel

Your screen captures tell nothing by the way, they're different numbers and no
indication what actually "fails".

If you insist on reopening this bug again, I'm deassigning myself. If you want
someone to entirely rewrite the numeric overall behaviour to implement
arbitrary-precision arithmetic then this bug is not the place for that.

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to