[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 #9 from GerardF <gerard.fargeot at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190107/be780e38/attachment.html>