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) Mathematical Markup Language (ISO/IEC 40314) [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]
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 projects - both open standards and open source - for Computer security, 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.

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, standardized as ISO 26300, 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.

OpenFormula is an open standard for exchanging recalculated formulae in spreadsheets. OpenFormula is included in version 1.2 of the OpenDocument standard. OpenFormula was initially proposed and drafted by David A. Wheeler.

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

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 Microsoft Open Specification Promise is a promise by Microsoft, published in September 2006, to not assert its patents, in certain conditions, against implementations of a certain list of specifications.

The line breaking rules in East Asian languages specify how to wrap East Asian Language text such as Chinese, Japanese, and Korean. Certain characters in those languages should not come at the end of a line, certain characters should not come at the start of a line, and some characters should never be split up across two lines. For example, periods and closing parentheses are not allowed to start a line. Many word processing and desktop publishing software products have built-in features to control line breaking rules in those languages.

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 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