[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