familyiop.blogg.se

Looks like this 'tradition' was carried over from Excel to LibreOffice Calc. 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 I don't know a direct comparison of Excel formulas vs OpenOffice (I'm not sure if there is such a thing).īut recommend using Excel Online instead of OpenOffice.What system does LibreOffice Calc use to represent timestamps as numbers? All aspects of your home finances can be. It will track your income (monthly and yearly) and compare that with your monthly and yearly expenses. It's free just like Openoffice and you can upgrade to a subscription version whenever you feel the need. This spreadsheet will allow you to set a yearly budgeted amount for numerous categories and then track your spending in all of them comparing it to your budgeted amount, just like a business. Work (at least) with Excel for the web when it comes to sharing Excel workbooks. I haven't used OpenOffice and I don't know the formulas. In many cases, the savings in licensing costs for a Microsoft Office suite are less than the cost of large-scale document conversions, when the labor time for the conversion is factored in. So before you migrate a file, it is recommended that you plan this migration very carefully. xlsx file directly, but if you want to edit it, you would have to convert it. In the new version of Openoffice you can open an. Excel files to OpenOffice, or vice versa, always involves some compatibility problems.