[Libreoffice-bugs] [Bug 144697] New: Dates prior to the program's limit should display #FMT

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 144697
           Summary: Dates prior to the program's limit should display #FMT
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: mikekaganski at hotmail.com

Put number -12661742 into A1, -12661743 into A2, -12662108 into A3.
Format all these as date (YYYY-MM-DD)

A1 displays reasonable '-32767-01-01'; A2 displays '--32768-12-31' (note two
dashes, although the date itself *looks* reasonable); A3 (365 days before A2)
displays unexpected '--32767-12-31' - see how the year changes in the wrong
direction.

Obviously there was a numeric overflow when formatting the year.

Bug 129878 had introduced a dedicated "#FMT" indication for numbers not
representable in the chosen formatting. This should be used for dates as well,
which can't be displayed reasonably - like those outside of '-32767-01-01'
(-12661742).

-- 
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/20210924/26a3024b/attachment.htm>