<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#c5">Comment # 5</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>(In reply to Eike Rathke from <a href="show_bug.cgi?id=133260#c4">comment #4</a>) > 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. Sure, asked the original reporter for one on the Chinese forum. [...] > 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? This is easier to test. According to two users with "Microsoft Office Home and Student 2019" and "Microsoft 365" respectively, Excel returns 6 for that formula. So does this mean the scope of the issue is much larger than just SUMIFS()?</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>