https://bugs.documentfoundation.org/show_bug.cgi?id=170299
Regina Henschel <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #4 from Regina Henschel <[email protected]> --- Example: 6^24 results in 4738381338321620000 instead of 4738381338321616896. It is rounded to 15 significant digests. And the rounded value mod 5 is zero. LibreOffice has no special integer arithmetic but uses the precision of "double" data type. And from its 52 significant bits you can get only about 15 significant digits in a decimal representation of the number. Thus it is not an "overflow" problem but a problem of precision. LibreOffice does not consider this as bug. See https://help.libreoffice.org/26.8/en-US/text/scalc/01/calculation_accuracy.html The same precision problem occurs when calculating MOD(1.5^n; 5). It is only accurate for n=1,2,3,...,14. For integers greater than 14, Excel does not display an error message in this case. This is inconsistent in Excel. -- You are receiving this mail because: You are the assignee for the bug.
