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: [email protected]
Reporter: [email protected]
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.
