[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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|Function error in Calc      |FREQUENCY may have to force
                   |                            |array mode on its arguments
            Version|4.1 all versions            |Inherited From OOo

--- Comment #6 from Eike Rathke <erack at redhat.com> ---
Odd. The Microsoft documentation for FREQUENCY() says "Because FREQUENCY
returns an array, it must be entered as an array formula."
https://support.office.com/en-US/article/FREQUENCY-function-44E3BE2B-ECA0-42CD-A3F7-FD9EA898FDB9

Which on the other hand is misleading, because if just a data range and a bins
range is given and not in array mode the function returns an array
nevertheless, but they probably mean that the function is to be entered as
array formula across a selected cell range to display the array and not just
the first value.

What's problematic here is the $L$11:$L$1000>=0 subexpression, which in this
context with a range works only in array mode and otherwise doesn't result in
an implicit intersection when given on row 7, hence the #VALUE! error; also
ROW() not in array mode returns only the first row of a range, not an array.

ECMA-376-1:2016 OOXML 18.17.7.127 FREQUENCY
says "A call to FREQUENCY shall be an array formula."
but on the other hand doesn't say anything like that about 18.17.7.309
SUMPRODUCT which definitely forces array mode on its arguments, or any other
function known to force array mode.

We may have to submit an update to ODFF as well that doesn't state the
ForceArray attribute
https://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#FREQUENCY

-- 
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/e92929be/attachment.html>