[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 #22 from Winfried Donkers <winfrieddonkers at libreoffice.org> ---
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.)

-- 
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/c5aa9aeb/attachment.html>