How to save .ods spread sheet (OpenOffice.org) to .xlsx (MS Office Excel 2007)

excel ms-office excel-formula openoffice.org openoffice-calc
Prahalad Gaggar picture Prahalad Gaggar · May 21, 2013 · Viewed 33.8k times · Source

Recently I switched from MS Office to OpenOffice.org 3.4.1.

Here are my questions:

  1. I was not able to save .ods spread sheet to .xlsx 2007 Format.
    The option which I got when I use Save As was Microsoft Excel 97/2000/XP (.xls) (*.xls)

  2. I was not able to use in MS Office Excel 2007 formula in Open Office org.
    Example a Formula like
    =IF(AND(A2<>"";B3<>"");"";IF(AND(B3="";B2<>"");"GO";IF(A3="";",";"")))
    Here is the test file for Formula MS Excel 2007 and Office Org

Edit:

Problem 2 is solved. The formula couldn't be copies at first. Also instead of , we have to use ; in OpenOffice.org

But I am still couldn't figure out how to save as xlsx.

I hope someone can help me.

Answer

orcmid picture orcmid · May 21, 2013

Apache OpenOffice 3.4.1 (and earlier versions) does not store in OOXML formats (.docx, .xslx, .pptx). I don't know if that will be remedied in the forthcoming Apache OpenOffice 4.0 or not.

An alternative that does have some conversion capability for OOXML in both directions is LibreOffice.

Related questions

What is a correct mime type for docx, pptx etc?

For older *.doc documents this was enough: header("Content-Type: application/msword"); What mime type should I use for new docx documents? Also for pptx and xlsx documents?

Read More
Reading Excel files from C#

Is there a free or open source library to read Excel files (.xls) directly from a C# program? It does not need to be too fancy, just to select a worksheet and read the data as strings. So far, I've …

Read More
How to read data from excel file using c#

My application needs to read data from an excel file. I am using .Net and c# for development. I cannot install MS office in the system. Because of that the my application fails to read excel file and throws an …

Read More