[Libreoffice-bugs] [Bug 138313] MONTHS() function gives the wrong result

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Tue Dec 1 13:53:13 UTC 2020


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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |NOTABUG

--- Comment #11 from Eike Rathke <erack at redhat.com> ---
As Uwe said and lined out with his example.

Type/mode 0 returns the interval in full months.
Type/mode 1 returns the difference in number of calendar months (as if you are
looking at a paper calendar and count number of paper sheets seen).

And no, all functions implemented in the scaddins/source/datefunc/ Add-In
didn't exist in Excel back then (and don't today), they are also not included
in the ODF OpenFormula (ODFF) standard.

Not a bug.

-- 
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/20201201/48247929/attachment-0001.htm>


More information about the Libreoffice-bugs mailing list