how to open openoffice excel file in microsoft excel

Open Menu ' Tools' -> ' Options' -> ' Libreoffice Calc' -> ' Calculate':īut. In my german-localized version, the options dialogue looks like this:Ĭalc is able to use the 1904 date system, too. To change the date system, open ' Tools' -> ' Options' and look for the ' Calculation' section. But this won't solve your initial problem (see below). To be sure, there's a quick solution making Excel to display dates instead of # symbols: change the epoch to the 1904 date system. So, i fear there's no overall solution for converting dates between the two office suits that cover every possible use case. You can enter such dates in Excel only as strings, using the apostrophe to mark the cell content explicitly as string. Especially, Excel doesn't support calculations for dates before 1900. Therefore, this option is only recommended if you know that the recipient of the file does not have any of the newer Excel versions.Converting dates from OOo/LO Calc to MS Excel has to consider Excel's inherent restrictions regarding the handling of dates (see HP005199291 regarding Excel 2003 and HP010342495 for Excel 2013). However, some functions of the XLSX file may not be available in the XLS file, or the formatting may look slightly different.

This will allow all Excel versions published since 1997 to open the file. To do so, use the “Save as” option and select the “Excel 97-2003 Workbook (*.xls)” option under “File type”.

On the other hand, you can still save a file in the old XLS format in all new versions of Excel. However, sometimes the content may not match the original exactly, especially in terms of the format. For example, the open source software LibreOffice is compatible with Microsoft’s current file extensions. Programs from other publishers can also handle XLSX files. Microsoft itself offers a solution through Excel Online which you can use directly in your browser. However, you do not necessarily need to buy a new version of Excel to open XLSX files. That means it is no longer possible to open and work with the new format in older versions of Excel. The free-to-use Excel Viewer, which was used by many to open the new file format, is also no longer officially provided by the publisher. However, this download is no longer officially available. For older versions, such as Excel 2003, you used to be able to download a compatibility pack from the Microsoft homepage.

How to open openoffice excel file in microsoft excel