[Libreoffice-bugs] [Bug 105174] IsLeapYear function gives erratic results.
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Thu Sep 23 19:14:52 UTC 2021
https://bugs.documentfoundation.org/show_bug.cgi?id=105174
Mike Kaganski <mikekaganski at hotmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|INSUFFICIENTDATA |NOTABUG
--- Comment #8 from Mike Kaganski <mikekaganski at hotmail.com> ---
This was indeed NOTABUG. As GerardF mentioned in comment 3, ISLEAPYEAR expects
a *date* as its argument, while Louie used calculation like '=ISLEAPYEAR(2021)'
to learn is 2021 was a leap year. The correct calculation would be e.g.
'=ISLEAPYEAR("2021-01-01")'.
--
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/20210923/b239e1df/attachment.htm>
More information about the Libreoffice-bugs
mailing list