Hi All
I have bunch of 50 to 100 .ods files. I need to convert .ods to .xls file formate, Is there any open office macro or VBA macro to convert these .ods files.
Thanks
John
Batch Conversion .ods to. xlsx
Batch Conversion .ods to. xlsx
OpenOffice 3.1 on Windows Vista / NeoOffice 2.2.3 with MacOS 10.4 / OpenOffice 2.4 on Ubuntu 9.04
Locale: en-US (en_US); Calc: group
Locale: en-US (en_US); Calc: group
Re: Batch Conversion .Ods to. xlsx
The .xlsx anrd the .xls are basicly different file formats. The .xlsx format is descripted in the OOXML Standard. It has two main versions: The Strict and the Transitional.
Batch Conversion .Ods to. xlsx
postby John008 » 2017 Sep 12, 9:27 am
Hi All
I have bunch of 50 to 100 .ods files. I need to convert .ods to .xls file formate, Is there any open office macro or VBA macro to convert these .ods files.
The .xls filformat never was standardized, and it has many different subversions.
The AOO can not save into the OOXML fileformats.
The LibreOffice can, but it can save into the Strict version of the OOXML Standard, the MS Office supports (by default) the Transitional version of the Standard (because they can change it when they want it to do).
Never was (and never will be) 100% compatibility between the different fileformats. You will lost some formatting and other properties at every conversion.
Conclusion: always use the International Standard ODF fileformats.
OtherWise the AOO and LO has a batch conversion wizard to ODF format...
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: Batch Conversion .Ods to. xlsx
See [Tutorial] Differences between Writer and MS Word files for why you should always work in and save files as .odt.
LO 6.4.4.2, Windows 10 Home 64 bit
See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.
Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.
Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
Re: Batch Conversion .Ods to. xlsx
See [Tutorial] Differences between Writer and MS Word files for why you should always work in and save files as .odt. It applies even more so to spreadsheets where the differences are greater.
LO 6.4.4.2, Windows 10 Home 64 bit
See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.
Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.
Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
Re: Batch Conversion .Ods to. xlsx
Note also that macros in .ods files will not work in .xls formats,
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Re: Batch Conversion .ods to. xlsx
I have only Mircrosoft Office 2007 version . Is there any possibilities to convert .ods to .xls file format
OpenOffice 3.1 on Windows Vista / NeoOffice 2.2.3 with MacOS 10.4 / OpenOffice 2.4 on Ubuntu 9.04
Locale: en-US (en_US); Calc: group
Locale: en-US (en_US); Calc: group
Re: Batch Conversion .ods to. xlsx
That is a 10 years old software...I have only Mircrosoft Office 2007 version .
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: Batch Conversion .ods to. xlsx
@John008: It is possible to convert .ods to .xls however you must be prepared for the possibility of formatting and/or data being lost in the conversion process.
If you don't have a lot of files, simply open the .ods file in Calc, then use File -> Save As (and follow the dialogs that come up to select the correct format you want to save in)
If you have a lot of files, then you might want to consider using Zamzar for the conversion process
If you don't have a lot of files, simply open the .ods file in Calc, then use File -> Save As (and follow the dialogs that come up to select the correct format you want to save in)
If you have a lot of files, then you might want to consider using Zamzar for the conversion process
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.