<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#c9">Comment # 9</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:gerard.fargeot@orange.fr" title="GerardF <gerard.fargeot@orange.fr>"> GerardF</a> <pre>(In reply to Eike Rathke from <a href="show_bug.cgi?id=122301#c8">comment #8</a>) > 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. Result in Office 365 is -3</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>