[Libreoffice-bugs] [Bug 122301] FREQUENCY may have to force array mode on its arguments
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Mon Jan 7 18:37:00 UTC 2019
https://bugs.documentfoundation.org/show_bug.cgi?id=122301
--- Comment #11 from Eike Rathke <erack at redhat.com> ---
@GerardF:
Umm.. to check whether my assumption about the "array in non-array mode"
actually holds, this
=SUM(-ABS({1,2}))
does produce -1, yes?
If -1, one more please to check whether array mode is indeed forced onto the
entire formula or just to the expression part that contains the FREQUENCY()
call:
=SUM(-ABS(FREQUENCY({1,1,-1},{0,1})))+SUM(-ABS({1,2}))
Should produce -6 if the entire formula in array mode (which I'd assume), or -4
if only the subexpression containing FREQUENCY() is in array mode.
--
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/d3af2836/attachment-0001.html>
More information about the Libreoffice-bugs
mailing list