https://bugs.documentfoundation.org/show_bug.cgi?id=122301
--- Comment #8 from Eike Rathke <er...@redhat.com> ---
Ok, what does Excel produce for
=SUM(-ABS(FREQUENCY({1,1,-1},{0,1})))
If it forces array mode on the entire formula the result should be -3
If it does not force array mode the result should be -1
Explanation:
The FREQUENCY result here is an array {1,2,0}.
ABS() in non-array mode takes one (the first) scalar value and returns 1, which
negated is -1, of which the SUM() is -1.
ABS() in array mode iterates over the array and returns {1,2,0}, which negated
is {-1,-2,0}, of which the SUM() is -3. That would be the same as if the
formula was entered in array mode.
Could someone with access to Excel please check? Thanks.
--
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
