Open an OpenDocument Spreadsheet in Excel. Find the file you want to open, and then click Open. Note: When you open an OpenDocument Spreadsheet file in Excel, it might not have the same formatting as it did in the original application it was created in. This is because of the differences between applications that use the OpenDocument Format. Converting files for Open Office Spreadsheet. Using Zamzar it is possible to convert a variety of formats to the Open Office Spreadsheet. Please see a list of supported formats below: csv to Open Office Spreadsheet (Comma Separated Values) wks to Open Office Spreadsheet (Microsoft Works Spreadsheet).
Related Articles
- 1 Recovering Deletions in Excel
- 2 Get Rid of Unneeded Cells in Excel
- 3 Save a File in CSV Format in Microsoft Office 2007
- 4 Do an Outline in Excel
In the free open-source office suite Apache OpenOffice, Calc is the spreadsheet equivalent to Microsoft Excel. Calc allows you to open and edit files originally saved in other programs and formats, including Excel XLS and XLSX. Although many elements on a spreadsheet saved in Excel are supported by Calc, some do not work or run the same way or at all.
Supported Elements
Calc allows you to open both non-protected and password-protected Excel files. Ft231x usb uart driver. In general, Calc displays formulas, charts, tables, objects, text formatting, colors, 3D effects and list styles as you might see them in Excel. It even supports pivot table data and the original physical dimensions of pie chart graphics.
Problem Areas
Calc isn’t entirely compatible with Excel. For example, Calc doesn’t use Visual Basic for Applications for macro creation like Excel does. Additionally, Calc doesn’t handle all types of formulas the same way as Excel. As a result, you will need to rewrite certain macros and formulas to make them work in Calc.
Disclaimer
Information in this article applies to OpenOffice 4.0 as of January 2014. It may vary slightly or significantly with other versions or products.
Excel Cannot Open The File
References (3)
About the Author
Based in Southern Pennsylvania, Irene A. Blake has been writing on a wide range of topics for over a decade. Her work has appeared in projects by The National Network for Artist Placement, the-phone-book Limited and GateHouse Media. She holds a Bachelor of Arts in English from Shippensburg University.
Cite this Article