[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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |erack at redhat.com
             Status|UNCONFIRMED                 |NEEDINFO
     Ever confirmed|0                           |1

--- Comment #4 from Eike Rathke <erack at redhat.com> ---
Can we please have an original Excel sample file attached, not a WPS generated
one, to see what Excel actually stores for this case? Thanks.

And yes, one has to modify a formula expression before a change is detected,
otherwise the formula cell is not re-entered, appending and removing a blank is
already enough. This is independent of whether a function would force array
mode or not.

Btw, can someone please check if Excel forces array mode whenever an inline
array is present as argument where the parameter expects a scalar value (like
SUMIFS() 3rd parameter)? For example
=SUM(ABS({-2,-4}))
does that yield 2 or 6?

-- 
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/20200525/d9adbe88/attachment.htm>