Comparison of Office Open XML and OpenDocument

Last updated

This is a comparison of the Office Open XML document file format with the OpenDocument file format.

Contents

Comparison

File formatOffice Open XMLOpenDocument
Based on a format
developed by
Microsoft StarDivision / Sun Microsystems
Predecessor file format Microsoft Office XML formats OpenOffice.org XML
Standardized by Ecma International, ISO/IEC OASIS, ISO/IEC
First public release date20062005
First stable versionEcma International Standard ECMA-376 Office Open XML File Formats 1st editionOASIS OpenDocument Format for Office Applications (OpenDocument) v1.0
Latest stable versionISO/IEC IS 29500-1:2012—Office Open XML File Formats [1] OASIS Open Document Format for Office Applications (OpenDocument) v1.3
Latest ISO/IEC standardised versionISO/IEC IS 29500-1:2012—Office Open XML File Formats [1] ISO/IEC IS 26300-1:2015—Open Document Format for Office Applications (OpenDocument) v1.2 [2]
Language type Markup language (XML) Markup language (XML)
XML schema representation XML Schema (W3C) (XSD) and RELAX NG (ISO/IEC 19757-2) RELAX NG (ISO/IEC 19757-2)
Expression of extensibility rules NVDL (ISO/IEC 19757-4)
Compression format ZIP ZIP
Container structure Open Packaging Conventions (ISO/IEC 29500-2:2021) [3] ODF Package [4]
Metadata format Dublin Core (ISO 15836)subset of Dublin Core and “urn:oasis:names:tc:opendocument:xmlns:meta” elements
Drawing language DrawingML, VML “urn:oasis:names:tc:opendocument:xmlns:drawing” elements and “urn:oasis:names:tc:opendocument:xmlns:svg-compatible” elements
Mathematical notation language Office MathML (OMML) MathML [5] [6]
Change-trackingsupported [7] supported [8]
Conditional formatting in spreadsheetssupported [9] supported [10]
Spreadsheet formula languagepart of the standard[ citation needed ]based on OpenFormula
Macro languageapplication-definedapplication-defined
Digital signaturespart of the standard[ citation needed ]supported
Thumbnails JPEG (ISO/IEC 10918) PNG (ISO/IEC 15948)
Interchange of digital font information Open Font Format (ISO/IEC 14496-22)
PANOSE font specificationspart of the standard [11]
Filename extensionsdocx, docm, xlsx, xlsm, pptx, pptmodt, ods, odp, odg, odf
Internet media types

application/vnd.openxmlformats-officedocument.wordprocessingml.document
application/vnd.ms-word.document.macroEnabled.12
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
application/vnd.ms-excel.sheet.macroEnabled.12
application/vnd.openxmlformats-officedocument.presentationml.presentation application/vnd.ms-powerpoint.presentation.macroEnabled.12

application/vnd.oasis.opendocument.text
application/vnd.oasis.opendocument.spreadsheet
application/vnd.oasis.opendocument.presentation
application/vnd.oasis.opendocument.graphics
application/vnd.oasis.opendocument.formula

Application support Office Open XML software OpenDocument software
Standard licensing
  • ISO/IEC copyrighted free download [12]
  • Ecma copyrighted free download / copying allowed
  • ISO/IEC copyrighted free download [12]
  • OASIS copyrighted free download / copying allowed
Additional technology patent licensing
  • Sun Microsystems intellectual property covenant
  • IBM Interoperability Specifications Pledge [15]
Implementations covered by patent licensePatent license covers conforming implementations [13] Patent license covers fully compliant implementations [15]
Implemented Microsoft Office 2013 (and later) [16] [17] [18] [19] Collabora Office, Collabora Online, [20] LibreOffice (for Microsoft Office 2007 Office Open XML) and SoftMaker Office Many including Collabora Office, Collabora Online, [21] LibreOffice, OpenOffice.org, KOffice, AbiWord, Lotus Notes and Microsoft Office (since 2007 SP2)
File formatOffice Open XMLOpenDocument


See also

Related Research Articles

The Organization for the Advancement of Structured Information Standards is a nonprofit consortium that works on the development, convergence, and adoption of open standards for cybersecurity, blockchain, Internet of things (IoT), emergency management, cloud computing, legal data exchange, energy, content technologies, and other areas.

An open file format is a file format for storing digital data, defined by an openly published specification usually maintained by a standards organization, and which can be used and implemented by anyone. An open file format is licensed with an open license. For example, an open format can be implemented by both proprietary and free and open-source software, using the typical software licenses used by each. In contrast to open file formats, closed file formats are considered trade secrets.

Vector Markup Language (VML) is an obsolete XML-based file format for two-dimensional vector graphics. It was specified in Part 4 of the Office Open XML standards ISO/IEC 29500 and ECMA-376. According to the specification, VML is a deprecated format included in Office Open XML for legacy reasons only.

A document file format is a text or binary file format for storing documents on a storage media, especially for use by computers. There currently exist a multitude of incompatible document file formats.

The Open Document Format for Office Applications (ODF), also known as OpenDocument, is an open file format for word processing documents, spreadsheets, presentations and graphics and using ZIP-compressed XML files. It was developed with the aim of providing an open, XML-based file format specification for office applications.

Ecma International is a nonprofit standards organization for information and communication systems. It acquired its current name in 1994, when the European Computer Manufacturers Association (ECMA) changed its name to reflect the organization's global reach and activities. As a consequence, the name is no longer considered an acronym and no longer uses full capitalization.

Open XML Paper Specification is an open specification for a page description language and a fixed-document format. Microsoft developed it as the XML Paper Specification (XPS). In June 2009, Ecma International adopted it as international standard ECMA-388.

The OpenDocument format (ODF), an abbreviation for the OASIS Open Document Format for Office Applications, is an open and free document file format for saving and exchanging editable office documents such as text documents, spreadsheets, databases, charts, and presentations. This standard was developed by the OASIS industry consortium, based upon the XML-based file format originally created by OpenOffice.org, and ODF was approved as an OASIS standard on May 1, 2005. It became an ISO standard, ISO/IEC 26300, on May 3, 2006.

This is an overview of software support for the OpenDocument format, an open document file format for saving and exchanging editable office documents.

<span class="mw-page-title-main">Rick Jelliffe</span>

Richard (Rick) Alan Jelliffe is an Australian programmer and standards activist, particularly associated with web standards, markup languages, internationalization and schema languages. He is the founder and Chief Technical Officer of Topologi Pty. Ltd, an XML tools vendor in Sydney. He has a degree in economics from the University of Sydney.

Office Open XML is a zipped, XML-based file format developed by Microsoft for representing spreadsheets, charts, presentations and word processing documents. Ecma International standardized the initial version as ECMA-376. ISO and IEC standardized later versions as ISO/IEC 29500.

This article describes the technical specifications of the OpenDocument office document standard, as developed by the OASIS industry consortium. A variety of organizations developed the standard publicly and make it publicly accessible, meaning it can be implemented by anyone without restriction. The OpenDocument format aims to provide an open alternative to proprietary document formats.

The following article details governmental and other organizations from around the world who are in the process of evaluating the suitability of using (adopting) OpenDocument, an open document file format for saving and exchanging office documents that may be edited.

The Open Document Format for Office Applications, commonly known as OpenDocument, was based on OpenOffice.org XML, as used in OpenOffice.org 1, and was standardised by the Organization for the Advancement of Structured Information Standards (OASIS) consortium.

The Open Packaging Conventions (OPC) is a container-file technology initially created by Microsoft to store a combination of XML and non-XML files that together form a single entity such as an Open XML Paper Specification (OpenXPS) document. OPC-based file formats combine the advantages of leaving the independent file entities embedded in the document intact and resulting in much smaller files compared to normal use of XML.

The Office Open XML file formats, also known as OOXML, were standardised between December 2006 and November 2008, first by the Ecma International consortium, and subsequently, after a contentious standardization process, by the ISO/IEC's Joint Technical Committee 1.

The Office Open XML format (OOXML), is an open and free document file format for saving and exchanging editable office documents such as text documents, spreadsheets, charts, and presentations.

The Office Open XML file formats are a set of file formats that can be used to represent electronic office documents. There are formats for word processing documents, spreadsheets and presentations as well as specific formats for material such as mathematical formulas, graphics, bibliographies etc.

References

  1. 1 2 "ISO/IEC 29500-1:2016". ISO. Retrieved 2023-04-17.
  2. "ISO/IEC 26300-1:2015". ISO. Retrieved 2023-04-17.
  3. "ISO/IEC 29500-2:2021". ISO. Retrieved 2023-04-17.
  4. "Erwin's StarOffice Tango". Archived from the original on 2008-01-17. Retrieved 2009-05-14.
  5. "ODFValidator - Apache OpenOffice Wiki".
  6. "A Demo: Mathematica, MathML and ODF". 20 August 2006.
  7. "Doug Mahugh".
  8. Jean Weber. "OpenOffice.org Writer for Microsoft Word users". Documentation.openoffice.org. Retrieved 2022-11-18.
  9. "Doug Mahugh".
  10. "Conditional Formatting in OpenOffice Calc Spreadsheets".
  11. W3C Panose document standard proposal
  12. 1 2 Freely Available ISO Standards
  13. 1 2 "Microsoft Open Specification Promise". Microsoft . Retrieved 2008-12-05.
  14. "Ecma Office Open XML File Formats overview". Archived from the original on 2006-11-17. Retrieved 2008-12-05.
  15. 1 2 Interoperability Specifications Pledge
  16. "Microsoft's format "heading for failure"". Ars Technica. 2010-04-02. Retrieved 2010-04-23.
  17. "Microsoft Expands List of Formats Supported in Microsoft Office". Microsoft.com. 2008-05-21. Retrieved 2009-05-19.
  18. Lai, Eric (2008-05-27). "FAQ: Office 14 and Microsoft's support for ODF". Computerworld.com. Archived from the original on 2008-12-24. Retrieved 2009-05-19.
  19. Andy Updegrove (21 May 2008). "Microsoft Office 2007 to Support ODF - and not OOXML". ConsortiumInfo.org. Archived from the original on 2008-05-23. Retrieved 2009-05-19.
  20. Bärwaldt, Eric (2020-09-01). "Working Together Tools for collaborative office work". Linux Magazine (238/2020). For cross-platform use, the suite not only supports the Open Document Format (ODF) but also all newer Microsoft formats, which makes interaction with other office suites easier.
  21. Bärwaldt, Eric (2020). "Collaborative online office solutions". Admin Network & Security. 60/2020. The software also supports PDF across all modules. If required, users can also convert text files to the ePub format for displaying appear on ebook readers or with desktop software for reading ePub files.