<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - FILEOPEN XLSX: Calc doesn't handle SUMIFS() with array as the third parameter correctly" href="https://bugs.documentfoundation.org/show_bug.cgi?id=133260#c6">Comment # 6</a> on <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - FILEOPEN XLSX: Calc doesn't handle SUMIFS() with array as the third parameter correctly" href="https://bugs.documentfoundation.org/show_bug.cgi?id=133260">bug 133260</a> from <a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> Eike Rathke</a> <pre>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).</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>