[Libreoffice-bugs] [Bug 133260] FILEOPEN XLSX: Calc doesn't handle SUMIFS() with array as the third parameter correctly

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #6 from Eike Rathke <erack at redhat.com> ---
Yes. It looks like an inline array (unlike a cell range reference) as argument
where a scalar value is expected would force array mode of the entire formula
expression. Question remains what happens if it is not an inline array but an
array/matrix returned from a function that itself is not in a forced array
context. The results of these examples could be interesting:

=SUM(ABS(MUNIT(2)))

=SUM(ABS(MUNIT(2)*-1))

If both behave the same as with the inline array the result should be 2 for
both, otherwise 1 (for one or both expressions).

-- 
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/20200526/f803c598/attachment.htm>