https://bugs.documentfoundation.org/show_bug.cgi?id=144699
--- Comment #10 from Vollbracht <[email protected]> --- So do we have an agreement to have Julian calculation for all dates prior to 1582-10-15 (1582-10-4 or prior)? We 'd have to file a bug analogue to [[96756]] then: German TAG(DATUMWERT(("1582-10-04"))) is 14 instead of 4. TAG(<date>) still works Gregorian even on dates prior to Gregor. I guess it 'll be the same with DAY(<date>) then.(In reply to Mike Kaganski from comment #0) > Bugs 96756, 144678, 144687, 144692 show some of the problems arising from > our use of ICU's default Julian cutover date, which is 1582-10-15. There are > more to it, e.g. there's no way to be ISO-8601-compatible using YYYY-MM-DD > format, because ISO 8601 requires that all dates are sequential, while we > have a sequence break around the cutover. > > Note that the described problems are not limited to Calc; all modules use > the same formatter to recognize and display dates. > > It seems that it would be useful to not try to solve those bugs by making > them honor Julian calendar (that would need additional complexity, and would > not solve every problem); LibreOffice is not a tool that is intended to > demonstrate *some* specific historical event when displaying dates (at least > by default). > > The proposal is to use proleptic Gregorian calendar for all the > representable date range in LibreOffice; that would make all the mentioned > problems to get resolved automatically, introducing consistency. > > To not break existing documents, we likely need a new option (common to all > ODF document types), like "Use proleptic Gregorian for all dates". It should > be enabled by default in new documents, as well as in all imported documents > (e.g., Excel does not format dates prior to 1900-01-01, so there may no > compatibility issues with XLS(X) documents); but existing ODF documents, > where there's no such flag defined, should be treated as before. > > The option should *possibly* be located near current "Year (Two Digit)" > configuration option on General page (however, the latter option is not > document-specific, so my idea could be wrong; anyway, the location should be > common/independent for all modules). -- You are receiving this mail because: You are the assignee for the bug.
