[Libreoffice-bugs] [Bug 144678] New: Functions MONTHS and YEARS give wrong results for pre-1582-10-15 dates when used with last argument set to 1

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 144678
           Summary: Functions MONTHS and YEARS give wrong results for
                    pre-1582-10-15 dates when used with last argument set
                    to 1
           Product: LibreOffice
           Version: 3.4.0 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: mikekaganski at hotmail.com

Consider the following spreadsheet formulas:

=MONTHS("1599-12-22";"1599-12-23";1)
=MONTHS("1599-12-31";"1600-01-01";1)
=YEARS("1599-12-22";"1599-12-23";1)
=YEARS("1599-12-31";"1600-01-01";1)

They return 0, 1, 0, and 1, respectively, as one would expect.

Now consider these:

=MONTHS("1499-12-22";"1499-12-23";1)
=MONTHS("1499-12-31";"1500-01-01";1)
=YEARS("1499-12-22";"1499-12-23";1)
=YEARS("1499-12-31";"1500-01-01";1)

They return 1, 0, 1, 0, respectively - which is completely unexpected.
The problem is, that the former set of formulas is after 1582-10-15, which is
when Gregorian calendar was introduced, and the latter set is before that date;
the dates sent to the functions in the latter set get converted to serial dates
as Julian dates, but MONTHS and YEARS use proleptic Gregorian to determine the
result when calculating with calendar months/years.

In OOo 3.2 and LO 3.3.0.4, the latter set resulted in #VALUE!; while LO 3.4.0.1
already produces the values described above. Not a regression though, rather
implementation error?

-- 
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/3d88e0c2/attachment.htm>