Regardless of whether it is Microsoft Excel or Google Sheets, spreadsheets’ utility and ubiquity set it apart from other software applications in the same genre. Looks like this 'tradition' was carried over from Excel to LibreOffice Calc.You do not have to be a banker, a corporate or a blue-collared employee, or even a fresher out of college to encounter a spreadsheet.

See also My First BillG Review – Joel on Software and Set the Flux Capacitor for - The Daily WTF

Source: Why is the zero date in Access / SQL Server instead of 12/31? answer by wkl. As long as all your dates later than 1900-Mar-1, this should be of no concern. Users who switched from 123 to Excel would not have to make any changes to their data. Microsoft decided to continue Lotus' bug, in order to fully compatible. When Excel was introduced, 123 has nearly the entire market for spreadsheet software. Excel works this way because it was truly a bug in Lotus 123. In reality, the day after 1900-Feb-Mar-1. The year 1900 was not a leap year (the year 2000 is a leap year). This is because Excel behaves as if the date 1900-Feb-29 existed. Probably for historical reasons (pun intended) because of a bug in Lotus 1-2-3.Īctually, this number is one greater than the actual number of days. Source: Documentation/Calc Functions/DATE - The Document Foundation Wiki The day before this is 4th October 1582,Īnd Calc uses the Julian calendar for earlier dates. Calc calculates all dates back to 15th October 1582 Negative date-time serial numbers correspond to dates earlier thanĬalc's start date. Unexpected changes to the dates displayed. Paste cells containing date values between different spreadsheets,Ĭheck that both documents are set to use the same start date to avoid We recommend that you do not change this setting. Requirements for compatibility with legacy spreadsheet applications, General information about Calc's Date and Time functionsĬalc uses as the default start date (day 0) but you can go to Tools ▸ Options ▸ LibreOffice Calc ▸ Calculate to selectĪlternative start dates however, unless you have specific

What system does LibreOffice Calc use to represent timestamps as numbers?

Openoffice spread sheet scientific