https://bugs.documentfoundation.org/show_bug.cgi?id=89373
b. <newbie...@gmx.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |newbie...@gmx.de
--- Comment #19 from b. <newbie...@gmx.de> ---
@Bill Babb ... and others: 'SUM' is sensitive to the order of operands,
'=SUM(1E16; -1E16; 1)' -> 1 , '=SUM(1; 1E16; -1E16)' -> 0,
it's an effect of 'cancellation' and will truncate small operands in
subtraction to different degree (between 'nearly nothing' and 'total
extinction',
calc and excel process ranges with different strategies, thus expect
deviations,
--
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