<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_ASSIGNED " title="ASSIGNED - FREQUENCY may have to force array mode on its arguments" href="https://bugs.documentfoundation.org/show_bug.cgi?id=122301#c8">Comment # 8</a> on <a class="bz_bug_link bz_status_ASSIGNED " title="ASSIGNED - FREQUENCY may have to force array mode on its arguments" href="https://bugs.documentfoundation.org/show_bug.cgi?id=122301">bug 122301</a> from <a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> Eike Rathke</a> <pre>Ok, what does Excel produce for =SUM(-ABS(FREQUENCY({1,1,-1},{0,1}))) If it forces array mode on the entire formula the result should be -3 If it does not force array mode the result should be -1 Explanation: The FREQUENCY result here is an array {1,2,0}. ABS() in non-array mode takes one (the first) scalar value and returns 1, which negated is -1, of which the SUM() is -1. ABS() in array mode iterates over the array and returns {1,2,0}, which negated is {-1,-2,0}, of which the SUM() is -3. That would be the same as if the formula was entered in array mode. Could someone with access to Excel please check? Thanks.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>