https://bugs.documentfoundation.org/show_bug.cgi?id=152114
--- Comment #10 from Eike Rathke <er...@redhat.com> --- (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 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. (In reply to jcsanz from comment #8) > The first date is one day before 0001-01-01 (using > Gregorian proleptic calendar) and is a date that exists (this is 0001-01-01 > BC). Actually 0001-12-31 BCE ... (In reply to jcsanz from comment #9) > Maybe LibreOffice is trying to adapt dates to a specific calendar. But does > LibreOffice know which calendar I am using when I type the date? 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. -- You are receiving this mail because: You are the assignee for the bug.