https://bugs.documentfoundation.org/show_bug.cgi?id=50299
--- Comment #38 from k...@cox.net ---
My apologies, Aron Budea, I only use the versions of LibreOffice Calc that the
(X)Ubuntu repositories give me using sudo apt, sudo apt-get or the synaptic
package manager. However, to expand on your "main issue", the calculated values
of MOD(24.09,1)*100 and MOD(24.09,1) are displayed in general number format as
9 and 0.09, respectively. When they are copied to another document (e.g.,
gedit), they are pasted as 9 and 0.09, respectively; when their values are
copied to other cells, they are pasted as 8.99999999999999 and
0.0899999999999999, respectively; and if the cells are tested against each
other for equality,
MOD(24.09,1)*100 = 8.99999999999999 = 9 and MOD(24.09,1) = 0.0899999999999999 =
0.09 and 9 8.99999999999999 = 0 and . But 8.99999999999999 ≠ 9 and
0.0899999999999999 ≠ 0.09
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
