[Libreoffice-bugs] [Bug 122301] FREQUENCY may have to force array mode on its arguments

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #8 from Eike Rathke <erack at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190107/f2d506d5/attachment.html>