[Libreoffice-bugs] [Bug 118177] Truncating 8*27/27 equals 7 on FILEOPEN if a cell is formatted other than General

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #5 from Eike Rathke <erack at redhat.com> ---
Well, yes, =TRUNC(A3-1)*F3 does something different than =TRUNC((A3-1)*F3) if
the value in F3 is is not exactly a fraction of (A3-1). As A3 is an integer
that's the same as =(A3-1)*F3

If you loaded your document and widen column C to display all decimals (with
cell cursor on C3 press Shift+Alt+CursorRight) you'll see the actual result
7.99999999999999 that for a narrower column is rounded to 8. Same if a number
format 0.00000000000000 was applied.

-- 
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/20180615/e05da8b9/attachment.html>