OpenOffice & LibreOffice

 

The Office Open XML standard (OOXML)

Since Excel 2007, the *.xlsx file format is the default when saving an Excel workbook.

This is in fact a ZIP compressed file composed of several XML parts, using the Office Open XML standard.

The Excel Binary Workbook (*.xlsb) file format is also a ZIP compressed file, but instead of XML parts, it has binary parts.

The Office Open XML is easy to read and update programmatically, while the binary format is more efficient to load and save, so you should use it whenever the performance is important.

There are the following additional macro-enabled file formats, which may contain code:

  • Excel Macro-enabled Workbook (*.xlsm)
  • Excel Macro-enabled Template (*.xltm)
  • Excel Add-In (*.xlam)

The Open Document Format (ODF)

Source : https://wiki.documentfoundation.org/LibreOffice_OOXML

The Document Foundation promotes and supports Open Standards. Among them OpenDocument Format (ODF), that offers many benefits to citizens, governments and businesses, and sets the documents and users free from proprietary lock-in.

The reason we enthusiastically promote ODF, is that we believe that no other standard provides the right level of vendor neutrality with widespread participation and implementation. We believe that ODF's absence of lock-in future proofs investment in both documents and software, to the great benefit of all citizens, governments and businesses. The Document Foundation does not promote nor support OOXML.

Just like OpenOffice.org, LibreOffice lets its users handle documents in the format used by Microsoft Office 2007 and 2010. It is important to understand that these formats, also called OOXML are in fact somewhat different from the ISO standard bearing the same name; in fact it is unclear whether anyone is able to implement the ISO standard.

To avoid confusion, we will refer to the Microsoft formats produced by Microsoft Office as Microsoft Open XML (MOX) hereafter. To enable data interchange, LibreOffice and OpenOffice.org before it, has traditionally engaged with the reality of a world filled with data in many, less than ideal formats. Our users are used to exchanging data bi-directionally between many proprietary formats, and their Free Software equivalents. Indeed there are few choices for a non-dominant player to deliberately shun inter-operating, and remain relevant.


Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 International License.