[Libreoffice-bugs] [Bug 130049] New: ISO 8601 date representation of years BC is off by 1

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 130049
           Summary: ISO 8601 date representation of years BC is off by 1
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: LibreOffice
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: mikekaganski at hotmail.com
                CC: erack at redhat.com

ISO 8601 defines year 0000 in proleptic Gregorian calendar as what is 1 BC. So
dates BC represented in ISO 8601 should have year number with absolute value 1
less than in traditional notation. So e.g. the day before 0001-01-01 must be
formatted as 0000-12-31. In LO, this is shown as -0001-12-31.

To reproduce (e.g., in Calc):
1. Put number -693595 into A1
2. Format as YYYY-MM-DD => "0001-01-01"
3. Put formula `=A1-1` into A2
4. Format as YYYY-MM-DD => "-0001-12-31"

-- 
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/20200117/fb38b72f/attachment-0001.htm>