<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - FILEOPEN: XSLX - MODE results in wrong calculation" href="https://bugs.documentfoundation.org/show_bug.cgi?id=97977#c22">Comment # 22</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - FILEOPEN: XSLX - MODE results in wrong calculation" href="https://bugs.documentfoundation.org/show_bug.cgi?id=97977">bug 97977</a> from <a class="email" href="mailto:winfrieddonkers@libreoffice.org" title="Winfried Donkers <winfrieddonkers@libreoffice.org>"> Winfried Donkers</a> <pre>There are 3 MODE functions in Calc: MODE, MODE.SNGL and MODE.MULT. The first is should be fully ODF compliant, the other 2 are OOXML functions. The Excel function MODE (originating from Add-In function pack) has been declared obsolete by Microsoft and replaced with MODE.SNGL and MODE.MULT. The 'old' MODE function has retained for the time being. So, if MODE fully complies with ODFF1.2, that is OK. Upon exporting to OOXML, it ought to be renamed to MODE.SNGL of MODE.MULT (haven't time to figure out which, right now). Currently it isn't, it's saved as MODE in OOXML. Export to xls is more difficult. Creating a new function in Calc for an obsolete function and file type does seem to be the way to go. (BTW, this is a general problem with Add-in functions that are being replaced by Microsoft with new versions.)</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>