Login
Login

Comparison of Office Open XML and OpenDocument

{{Short description|none}}

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

Comparison

class="wikitable sortable" style="font-size:85%; border:gray solid 1px; text-align:center; width:100%;"
style="background: #ececec"

! style="width:15em" | File format

! Office Open XML

! OpenDocument

style="text-align:left; background: #ececec;" | Based on a format
developed by

| Microsoft

| StarDivision / Sun Microsystems

style="text-align:left; background: #ececec;" | Predecessor file format

| Microsoft Office XML formats

| OpenOffice.org XML

style="text-align:left; background: #ececec;" | Standardized by

| Ecma International, ISO/IEC

| OASIS, ISO/IEC

style="text-align:left; background: #ececec;" | First public release date

| 2006

| 2005

style="text-align:left; background: #ececec;" | First stable version

| Ecma International Standard ECMA-376 Office Open XML File Formats 1st edition

| OASIS OpenDocument Format for Office Applications (OpenDocument) v1.0

style="text-align:left; background: #ececec;" | Latest stable version

| ISO/IEC IS 29500-1:2012—Office Open XML File Formats{{Cite web |last= |title=ISO/IEC 29500-1:2016 |url=https://www.iso.org/standard/71691.html |access-date=2023-04-17 |website=ISO |language=en}}

| OASIS Open Document Format for Office Applications (OpenDocument) v1.3

style="text-align:left; background: #ececec;" | Latest ISO/IEC standardised version

| ISO/IEC IS 29500-1:2012—Office Open XML File Formats

| ISO/IEC IS 26300-1:2015—Open Document Format for Office Applications (OpenDocument) v1.2{{Cite web |last= |title=ISO/IEC 26300-1:2015 |url=https://www.iso.org/standard/66363.html |access-date=2023-04-17 |website=ISO |language=en}}

style="text-align:left; background: #ececec;" | Language type

| Markup language (XML)

| Markup language (XML)

style="text-align:left; background: #ececec;" | XML schema representation

| XML Schema (W3C) (XSD) and RELAX NG (ISO/IEC 19757-2)

| RELAX NG (ISO/IEC 19757-2)

style="text-align:left; background: #ececec;" | Expression of extensibility rules

| NVDL (ISO/IEC 19757-4)

|

style="text-align:left; background: #ececec;" | Compression format

| ZIP

| ZIP

style="text-align:left; background: #ececec;" | Container structure

| Open Packaging Conventions (ISO/IEC 29500-2:2021){{Cite web |last= |title=ISO/IEC 29500-2:2021 |url=https://www.iso.org/standard/77818.html |access-date=2023-04-17 |website=ISO |language=en}}

| ODF Package{{cite web |url=http://blogs.sun.com/dancer/entry/dispelling_myths_around_odf |title=Erwin's StarOffice Tango |access-date=2009-05-14 |archive-url=https://web.archive.org/web/20080117221036/http://blogs.sun.com/dancer/entry/dispelling_myths_around_odf |archive-date=2008-01-17 |url-status=dead }}

style="text-align:left; background: #ececec;" | Metadata format

| Dublin Core (ISO 15836)

| subset of Dublin Core and “urn:oasis:names:tc:opendocument:xmlns:meta” elements

style="text-align:left; background: #ececec;" | Drawing language

| DrawingML, VML

| “urn:oasis:names:tc:opendocument:xmlns:drawing” elements and “urn:oasis:names:tc:opendocument:xmlns:svg-compatible” elements

style="text-align:left; background: #ececec;" | Mathematical notation language

| Office MathML (OMML)

| Mathematical Markup Language (ISO/IEC 40314){{cite web|url=http://wiki.services.openoffice.org/wiki/ODFValidator|title = ODFValidator - Apache OpenOffice Wiki}}{{cite web|url=http://www.robweir.com/blog/2006/08/demo-mathematica-mathml-and-odf.html|title=A Demo: Mathematica, MathML and ODF|date=20 August 2006}}

style="text-align:left; background: #ececec;" | Change-tracking

| {{yes|supported}}{{cite web|url=http://blogs.msdn.com/dmahugh/archive/2009/05/13/tracked-changes.aspx|title=Doug Mahugh}}

| {{yes|supported}}{{cite web|author=Jean Weber |url=http://documentation.openoffice.org/HOW_TO/word_processing/Word-to-OOo.html |title=OpenOffice.org Writer for Microsoft Word users |publisher=Documentation.openoffice.org |date= |accessdate=2022-11-18}}

style="text-align:left; background: #ececec;" | Conditional formatting in spreadsheets

| {{yes|supported}}{{cite web|url=http://blogs.msdn.com/dmahugh/archive/2007/10/02/conditional-formatting.aspx|title = Doug Mahugh}}

| {{yes|supported}}{{cite web|url=http://openoffice.blogs.com/openoffice/2007/01/conditional_for.html?cid=123250788|title=Conditional Formatting in OpenOffice Calc Spreadsheets}}

style="text-align:left; background: #ececec;" | Spreadsheet formula language

| {{yes|part of the standard}}{{Citation needed|date=May 2010}}

| {{yes|based on OpenFormula}}

style="text-align:left; background: #ececec;" | Macro language

| {{no|application-defined}}

| {{no|application-defined}}

style="text-align:left; background: #ececec;" | Digital signatures

| {{yes|part of the standard}}{{Citation needed|date=May 2010}}

| {{yes|supported}}

style="text-align:left; background: #ececec;" | Thumbnails

| JPEG (ISO/IEC 10918)

| PNG (ISO/IEC 15948)

style="text-align:left; background: #ececec;" | Interchange of digital font information

| Open Font Format (ISO/IEC 14496-22)

|

style="text-align:left; background: #ececec;" | PANOSE font specifications

| {{yes|part of the standard}}[http://www.w3.org/Printing/stevahn.html W3C Panose document standard proposal]

|

style="text-align:left; background: #ececec;" | Filename extensions

| docx, docm, xlsx, xlsm, pptx, pptm

| odt, ods, odp, odg, odf

style="text-align:left; background: #ececec;" | 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

style="text-align:left; background: #ececec;" | Application support

| Office Open XML software

| OpenDocument software

style="text-align:left; background: #ececec;" | Standard licensing

|

  • ISO/IEC copyrighted free download[http://standards.iso.org/ittf/PubliclyAvailableStandards/index.html#ISOCopyrightforthefreelyavailablestandards Freely Available ISO Standards]
  • Ecma copyrighted free download / copying allowed

|

  • ISO/IEC copyrighted free download
  • OASIS copyrighted free download / copying allowed
style="text-align:left; background: #ececec;" | Additional technology patent licensing

|

| url=http://www.microsoft.com/interop/osp/

| title=Microsoft Open Specification Promise

| website=Microsoft

| accessdate=2008-12-05

}}

  • Microsoft Covenant Not to Sue (CNS){{cite web

| url=http://office.microsoft.com/en-us/products/HA102058151033.aspx

| title=Ecma Office Open XML File Formats overview

| accessdate=2008-12-05

| archive-url=https://web.archive.org/web/20061117042839/http://office.microsoft.com/en-us/products/HA102058151033.aspx

| archive-date=2006-11-17

| url-status=dead

}}

|

  • Sun Microsystems intellectual property covenant
  • IBM Interoperability Specifications Pledge[https://web.archive.org/web/20070717065439/http://www-03.ibm.com/linux/opensource/isplist.shtml Interoperability Specifications Pledge]
style="text-align:left; background: #ececec;" | Implementations covered by patent license

| {{yes|Patent license covers conforming implementations}}

| {{yes|Patent license covers fully compliant implementations}}

style="background: #ececec" class="sortbottom"

! File format

! Office Open XML

! OpenDocument

See also

References

{{Reflist|2}}

External links

  • [https://ecma-international.org/publications-and-standards/standards/ecma-376] ECMA-376: Office Open XML File Formats
  • [https://www.iso.org/standard/71691.html] ISO/IEC 29500-1:2016: Office Open XML File Formats
  • [https://www.iso.org/standard/66363.html] ISO/IEC 26300-1:2015: Open Document Format for Office Applications (OpenDocument) v1.2
  • [https://www.iso.org/standard/43485.html] ISO/IEC 26300:2006: Open Document Format for Office Applications (OpenDocument) v1.0
  • [https://www.iso.org/standard/45245.html] ISO/IEC TR 29166:2011: Guidelines for translation between ISO/IEC 26300 and ISO/IEC 29500 document formats
  • [https://ssrn.com/abstract=1201708 Lost in Translation: Interoperability Issues for Open Standards - ODF and OOXML as Examples]

{{Office document file formats}}

{{DEFAULTSORT:Office Open XML and OpenDocument comparison}}

Category:Office Open XML

Category:OpenDocument

Category:Markup language comparisons