https://bugs.documentfoundation.org/show_bug.cgi?id=152118
--- Comment #12 from Eike Rathke <[email protected]> --- The SQL statement outputs the raw data formatted as date, which is stored in the proleptic Gregorian calendar, and apparently dates before 0001-01-01 (i.e. negative dates or dates BCE) can not be stored in the database (if they could in Firebird then someone would have to implement that). The table grid view displays data in the locale's calendar. > I was supposed to use proleptic Gregorian calendar in Calc Calc does not use the proleptic Gregorian calendar. It uses the locale's default calendar. As explained in bug 152114 that usually is (does not have to be) the Gregorian calendar after the Gregorian cut-off date, and Julian calendar before that. If the cut-off date is 1582-10-15 (Gregorian) then subtracting 1 from that date yields 1582-10-04 (Julian). Btw, also for Calc .ods and other ODF file formats, dates are always stored in the proleptic Gregorian calendar. To solve this (expectation of display being what's stored) it would need an option to force the proleptic Gregorian calendar for display. -- You are receiving this mail because: You are the assignee for the bug.
