[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