https://bugs.freedesktop.org/show_bug.cgi?id=69736
Regina Henschel <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG CC| |[email protected] --- Comment #1 from Regina Henschel <[email protected]> --- 0.4 and 2.4 have infinite binary representations and therefore are truncated somewhere. Transforming the binary representation back to decimal, you would get something like 0.3999999999999999944488848768742172978818416595458984375 2.399999999999999911182158029987476766109466552734375 You will not see so many digits in the spreadsheet cell, because the display is rounded to 15 significant digits. So in fact you are trying to get a LCM of these values, and here one is not a multiple of the other. On the other hand 0.5 and 2.5 have short finite representations and it works. Shift your numbers to be integral with precision you need, round it to integral, calculate LCM, and shift it back. All function of kind _ADD are only provided as help in Excel import/export filter. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
