https://bugs.documentfoundation.org/show_bug.cgi?id=118177
--- Comment #5 from Eike Rathke <er...@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
