Comparison of Office Open XML and OpenDocument

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

Comparison

File format Office Open XML OpenDocument
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 date 2006 2005
First stable version Ecma International Standard ECMA-376 Office Open XML File Formats 1st edition OASIS OpenDocument Format for Office Applications (OpenDocument) v1.0
Latest stable version ISO/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 version ISO/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-tracking supported[7] supported[8]
Conditional formatting in spreadsheets supported[9] supported[10]
Spreadsheet formula language part of the standard[citation needed] based on OpenFormula
Macro language application-defined application-defined
Digital signatures part 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 specifications part of the standard[11]
Filename extensions docx, docm, xlsx, xlsm, pptx, pptm odt, 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 license Patent license covers conforming implementations[13] Patent license covers fully compliant implementations[15]
File format Office Open XML OpenDocument

See also

References

  1. ^ a b "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. ^ a b Freely Available ISO Standards
  13. ^ a b "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. ^ a b Interoperability Specifications Pledge