https://bugs.documentfoundation.org/show_bug.cgi?id=122301
--- Comment #9 from GerardF <gerard.farg...@orange.fr> ---
(In reply to Eike Rathke from comment #8)
> 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.
Result in Office 365 is -3
--
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
