Apache OpenOffice Community Forum

Later edit: Thanks guys, I did it myself after learing from other posts on this forum.

I have an excel Source.xlsx file with text and number data.

I want to open the excel file with the last version of OpenOffice (4.1.4) and run a macro in OpenOffice Calc that will take the data from my excel file and put in a new OpenOffice Spreadsheet file (.ods format).

This mean that the macro should run in OpenOffice Calc and create a new .ods file and populate it with data from the excel file I have open in OpenOffice Calc when I run the macro.

Attached is the detailed brief with an an example of the excel source file and the OpenOffice Calc destination file. Please note the password for the Destination.ods file is: test111

last version of OpenOffice (4.1.4)

This is no longer correct. The latest release of OpenOffice is 4.1.6

As you are wanting to take information from a .xlsx file and put it into a .ods file, rather than use a macro, have you considered using LibreOffice
LibreOffice has a higher level of compatibility with the later Microsoft versions (eg: .xlsx rather than .xls)

RusselB wrote:have you considered using LibreOffice

Thanks for the recommendation, now I switch to LibreOffice.
But I still need to use a macro in order to automate the process because the real source file have thousands of rows.

Seems this is much more complex than simply converting xlsx to ods; there is an amount of processing and formatting specified.

If this is a one off application it might be worth trying a conversion service such as http://www.zamzar.com

Zamzar might be an acceptable option, even if this is gping to be something on going.
The first limitation I can see is the size of the .xlsx file that Zamzar would be working with.
There are file size limits for all but the highest paid accounts.