https://bugs.documentfoundation.org/show_bug.cgi?id=152114
--- Comment #11 from [email protected] --- (In reply to Eike Rathke from comment #10) > (In reply to jcsanz from comment #0) > > 13. In the Field Format dialog box, in the Category list, select Date, > > and in the Format list, select 31/12/1999. Click the OK button. This will > > display the date in the same format as on the original Calc sheet. > That of course depends on the current locale and everyone will see something > different with the default date format, i.e. in an en-CA locale the default > format is YYYY-MM-DD Of course, depend on the locale you can view the date in a different way, but the date should be the same > > Now to the symptom: registering the Calc sheet as database and displaying > that converts content to a database view using formatted fields, with some > back-and-forth conversion (serial date number offset from the null-date to > date and back) involved that apparently has bugs with at least negative > proleptic Gregorian dates. With negative dates and 0001-01-01 and 0001-01-02. And maybe other different dates see tdf#152118 > > Gregorian proleptic calendar) and is a date that exists (this is 0001-01-01 > > BC). > Actually 0001-12-31 BCE ... Yes, of course, it was a slip > Input happens in the locale's default calendar, usually Gregorian, but for > dates before the Gregorian cut-off date (common is 1582-10-15 but depends on > locale) it is the Julian calendar. Internally stored is the date serial > number as day offset from the null-date, usually 1899-12-30 in LibreOffice. > Calculations use the proleptic Gregorian calendar, as well as document > storage. Well, ok ... but... If I've been taught that America was discover on October 12th, 1472, what calendar was using my teacher? I don't know, but I expect that if write 1472-10-12 (or 12/10/1472) it remains the same in Calc, in Writer, in Base and in whatever place it was used. And I don't expect the system adapt my date to a different calendar when I move the date from one component to other (regardless of the calendar used by me or configured in the application). Any case, I think there is a bug when 0001-01-01 and 0001-01-02 are converted to a different date but 0001-01-03 is not converted -- You are receiving this mail because: You are the assignee for the bug.
