<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#c7">Comment # 7</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:plateauwolf@qq.com" title="zh_CN User Community Liaison <plateauwolf@qq.com>"> zh_CN User Community Liaison</a> <pre>Created <a href="http://bugs.documentfoundation.org/attachment.cgi?id=161512" name="attach_161512" title="Same sample file as 161113, saved by MS Excel">attachment 161512</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=161512&action=edit" title="Same sample file as 161113, saved by MS Excel">[details]</a> Same sample file as 161113, saved by MS Excel Sample file saved by Excel attached. Also, (In reply to Eike Rathke from <a href="show_bug.cgi?id=133260#c6">comment #6</a>) > 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). Excel returns 2 for both formula.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>