[Libreoffice-bugs] [Bug 97977] FILEOPEN: XSLX - MODE results in wrong calculation

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=97977

--- Comment #23 from Dennis Roczek <dennisroczek at libreoffice.org> ---
(In reply to Winfried Donkers from comment #22)
> 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.
Hi Olivier, can you add a notice to the help that MODE is ODF-complaint? This
is missing in the help actually. (just noticed)

> 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.
Well then we do have another problem. :-(

I just tested with Excel 2016 O365 (desktop app) version: all three variants of
Mode (with the following numbers (9;1;5;1;9;5;6;6)) give as a result 9 back.

LibreOffice Calc does calculate a 1 (as stated in our help).

> 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.
Well, yes and no. The file format isn't open for extensions, this won't work
except mapping MODE.SNGL (or MODE.MULT) to MODE.

> (BTW, this is a general problem with Add-in functions that are being
> replaced by Microsoft with new versions.)
Depend if we have already a function integrated since ages. I wouldn't invent
new functions for such minimal differences...

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180227/30fe9a2f/attachment-0001.html>