OpenDocument

2024-02-03T08:28:05Z

Asciim0: updated toolkit links

{{FormatInfo
|formattype=electronic
|subcat=Document
|locfdd={{LoCFDD|fdd000247}}, others
|pronom={{PRONOM|fmt/135}}, others
|extensions={{ext|odm}}, {{ext|odt}}, {{ext|ods}}, {{ext|odg}}, {{ext|odp}}, {{ext|odc}}, {{ext|odi}}, {{ext|odf}}, {{ext|odb}}, {{ext|ott}}, {{ext|ots}}, {{ext|otg}}, {{ext|otp}}, {{ext|otc}}, {{ext|oti}}, {{ext|otf}}, {{ext|oth}}, {{ext|fodt}}, {{ext|fods}}, {{ext|fodg}}, {{ext|fodp}}
|released=2005
}}
'''OpenDocument''', also known as '''Open Document Format for Office Applications''' or '''ODF''', is a family of file formats designed to be used by word processors, spreadsheet applications, and other office applications. It is (more or less?) the successor to [[OpenOffice.org XML]]. These formats were developed by a group called OASIS, so they are sometimes referred to as "OASIS format" or "OASIS Open Document Format".

== Formats ==
{| class="wikitable"
! Format
! MIME type
! Extension
! PRONOM
! LoCFDD
|-
|OpenDocument
| || || {{PRONOM|fmt/135}} || {{LoCFDD|fdd000247}}, {{LoCFDD|fdd000424}}, {{LoCFDD|fdd000425}}
|-
|rowspan="2"|[[OpenDocument Text]]
|{{mimetype|application/vnd.oasis.opendocument.text}}
|.odt, .fodt
|rowspan="2"|{{PRONOM|fmt/136}}, {{PRONOM|fmt/290}}, {{PRONOM|fmt/291}}
|rowspan="3"|{{LoCFDD|fdd000427}}, {{LoCFDD|fdd000428}}
|-
|{{mimetype|application/vnd.oasis.opendocument.text-template}}
|.ott
|-
|[[OpenDocument Global Text Document|OpenDocument Global Text]]
|{{mimetype|application/vnd.oasis.opendocument.text-master}}
|.odm
|
|-
|[[OpenDocument HTML Template]]
|{{mimetype|application/vnd.oasis.opendocument.text-web}}
|.oth
|
|
|-
|rowspan="2"|[[OpenDocument Spreadsheet]]
|{{mimetype|application/vnd.oasis.opendocument.spreadsheet}}
|.ods, .fods
|rowspan="2"|{{PRONOM|fmt/137}}, {{PRONOM|fmt/294}}, {{PRONOM|fmt/295}}
|rowspan="2"|{{LoCFDD|fdd000438}}, {{LoCFDD|fdd000439}}
|-
|{{mimetype|application/vnd.oasis.opendocument.spreadsheet-template}}
|.ots
|-
|rowspan="2"|[[OpenDocument Drawing]]
|{{mimetype|application/vnd.oasis.opendocument.graphics}}
|.odg, .fodg
|rowspan="2"|{{PRONOM|fmt/139}}, {{PRONOM|fmt/296}}, {{PRONOM|fmt/297}}
|rowspan="2"|{{LoCFDD|fdd000436}}
|-
|{{mimetype|application/vnd.oasis.opendocument.graphics-template}}
|.otg
|-
|rowspan="2"|[[OpenDocument Presentation]]
|{{mimetype|application/vnd.oasis.opendocument.presentation}}
|.odp, .fodp
|rowspan="2"|{{PRONOM|fmt/138}}, {{PRONOM|fmt/292}}, {{PRONOM|fmt/293}}
|rowspan="2"|{{LoCFDD|fdd000435}}
|-
|{{mimetype|application/vnd.oasis.opendocument.presentation-template}}
|.otp
|-
|rowspan="2"|[[OpenDocument Chart]]
|{{mimetype|application/vnd.oasis.opendocument.chart}}
|.odc
|rowspan="2"|
|rowspan="2"|{{LoCFDD|fdd000437}}
|-
|{{mimetype|application/vnd.oasis.opendocument.chart-template}}
|.otc
|-
|rowspan="2"|[[OpenDocument Image]]
|{{mimetype|application/vnd.oasis.opendocument.image}}
|.odi
|rowspan="2"|
|rowspan="2"|
|-
|{{mimetype|application/vnd.oasis.opendocument.image-template}}
|.oti
|-
|rowspan="2"|[[OpenDocument Formula]]
|{{mimetype|application/vnd.oasis.opendocument.formula}}
|.odf
|rowspan="2"|
|rowspan="2"|
|-
|{{mimetype|application/vnd.oasis.opendocument.formula-template}}
|.otf
|-
|[[OpenDocument Database|OpenDocument Database Front End]]
|{{mimetype|application/vnd.oasis.opendocument.base}}<br>{{mimetype|application/vnd.oasis.opendocument.database}}
|.odb
|{{PRONOM|fmt/140}}, {{PRONOM|fmt/444}}, {{PRONOM|fmt/424}}
|{{LoCFDD|fdd000441}}
|}

== Identification ==
In most cases, OpenDocument files begin with the ASCII string "<code>PK</code>", have "<code>mimetype</code>" at offset 30, and "<code>application/vnd.oasis.opendocument.</code>" at offset 38.

== Specifications ==
* [https://www.oasis-open.org/standards#opendocumentv1.0 OpenDocument v1.0 specification]
* [https://www.oasis-open.org/standards#opendocumentv1.1 OpenDocument v1.1 specification]
* [https://www.oasis-open.org/standards#opendocumentv1.2 OpenDocument v1.2 specification]

== Software ==
* [https://www.libreoffice.org/ LibreOffice]
* [[Wikipedia:OpenDocument software|Wikipedia: OpenDocument software]]
* [[Wikipedia:Comparison of OpenDocument software|Wikipedia: Comparison of OpenDocument software]]
* [http://webodf.org/ WebODF]
* [https://github.com/unoconv/unoconv unoconv]
* [http://sourceforge.net/p/libwpd/wiki/libodfgen/ libodfgen library]
* [https://tdf.github.io/odftoolkit/conformance/ODFValidator.html LibreOffice ODF Toolkit] (Java) including:
** [https://tdf.github.io/odftoolkit/conformance/ODFValidator.html ODF Validator] (a cloud-hosted version of the validator is running [https://odfvalidator.org/ here].

=== ODF version support over time ===

{| class="wikitable"
|-
! scope="col" | ODF version
! scope="col" | Date of standard approval by OASIS
! scope="col" | First supporting version of the software
|-
| | ODF 1.0
| | 2005-05-01
| | OpenOffice.org 1.1.5 or StarOffice 7
|-
| | ODF 1.1
| | 2007-02-02
| | OpenOffice.org 2.2 or StarOffice 8 Update 4
|-
| | ODF 1.2
| | 2011-09-30
| | OpenOffice.org 3, StarOffice 9, Oracle Open Office
|-
| | ODF 1.2 (Extended)
| | -
| | OpenOffice.org 3.2 or StarOffice 9.2
|}

Taken from [https://help.libreoffice.org/Common/XML_File_Formats LibreOffice - XML File Formats].

== Sample files ==
* [http://craphound.com/homeland/Cory_Doctorow_-_Homeland.odt Homeland by Cory Doctorow]
* {{DexvertSamples|document/openDocument}}

== Links ==
* [[Wikipedia:OpenDocument|Wikipedia: OpenDocument]]
* [[Wikipedia:OpenDocument technical specification|Wikipedia: OpenDocument technical specification]]
* [http://www.opendocumentformat.org/ OpenDoc Society: opendocumentformat.org]
* [{{ForensicsWikiURL|open_document_format}} Forensic Wiki article]
* [http://www.linux-magazine.com/Online/Features/LibreOffice-vs.-OpenOffice LibreOffice vs OpenOffice: Comparative review]
* [http://m.theregister.co.uk/2014/01/30/uk_picks_open_document_format_for_all_government_files/ UK picks Open Document Format for all government files]
* [http://classic.slashdot.org/story/14/07/02/1349208 WebODF: JavaScript Open Document Format Editor Deemed Stable] (Slashdot discussion)
* [http://ask.libreoffice.org/en/question/648/is-it-possible-to-embed-fonts-in-a-writerimpresscalc-document/ Discussion of embedding fonts in ODF documents]
* [http://blogs.loc.gov/digitalpreservation/2016/01/odf-the-open-document-format/ ODF: The Open Document Format]
* [https://blogs.msdn.microsoft.com/dmahugh/2009/05/05/odf-spreadsheet-interoperability/ ODF Spreadsheet Interoperability] (Microsoft discussion)
* [http://wiki.opf-labs.org/display/TR/Images+not+embedded+because+of+paste+as+link+bug+in+OpenOffice+and+LibreOffice Images not embedded because of paste as link bug in OpenOffice and LibreOffice]

[[Category:ZIP based file formats]]
[[Category:XML based file formats]]

OpenDocument Spreadsheet

2024-02-03T08:17:27Z

Asciim0: added LibreOffice Validator

{{FormatInfo
|formattype=electronic
|subcat=Document
|subcat2=Spreadsheet
|extensions={{ext|ods}}, {{ext|fods}}, {{ext|ots}}
|mimetypes={{mimetype|application/vnd.oasis.opendocument.spreadsheet}}, {{mimetype|application/vnd.oasis.opendocument.spreadsheet-template}}
|locfdd={{LoCFDD|fdd000438}}, {{LoCFDD|fdd000439}}
|pronom={{PRONOM|fmt/137}}, {{PRONOM|fmt/294}}, {{PRONOM|fmt/295}}
|released=2005-05-01
}}
The '''OpenDocument Spreadsheet''' format is one of a number of types of the [[OpenDocument|Open Document Format for Office Applications]] (commonly referred to as OpenDocument), an [[XML]]-based file format defined by the Organization for the Advancement of Structured Information Standards (OASIS) in 2005.

OpenDocument Spreadsheets can, like all [[OpenDocument]] files, be represented in one of two fashions - as a single XML document or as a collection of several sub-documents within a single package (commonly a [[ZIP]] archive). Generally, the extension '''.fods''' is used for the uncommonly-used single XML documents and '''.ods''' for packaged sub-documents.

As of v1.2 of the OpenDocument specification, the format contains information regarding spreadsheet formulae, pivot tables, etc. in the [[OpenFormula]] format.

== Information ==

* [https://www.oasis-open.org/standards#opendocumentv1.0 OpenDocument v1.0 specification]
* [https://www.oasis-open.org/standards#opendocumentv1.1 OpenDocument v1.1 specification]
* [https://www.oasis-open.org/standards#opendocumentv1.2 OpenDocument v1.2 specification]
* [http://en.wikipedia.org/wiki/OpenDocument Wikipedia - OpenDocument]

== Variants ==

There are variants of the OpenDocument Spreadsheet format created by different software applications. Such files need to be treated differently and identified separately from standard OpenDocument Spreadsheet files

Rob Weir has done some work in identifying and documenting these differences. See the following for more information:

* [http://www.robweir.com/blog/2009/03/odf-spreadsheet-interoperability-theory-and-practice.html ODF Spreadsheet Interoperability: Theory and Practice]
* [http://www.robweir.com/blog/2009/05/update-on-odf-spreadsheet-interoperability.html Update on ODF Spreadsheet Interoperability]
* [http://www.robweir.com/blog/2009/05/follow-up-on-excel-2007-sp2s-odf.html A follow-up on Excel 2007 SP2′s ODF support]

Doug Mahugh's response to Rob's posts may also contain some useful information:

* [http://blogs.msdn.com/b/dmahugh/archive/2009/05/05/odf-spreadsheet-interoperability.aspx ODF Spreadsheet Interoperability]

Finally, Office.com has some information on the difference between their [[XLSX|Office Open XML Spreadsheet]] format and OpenDocument Spreadsheet.

* [http://office.microsoft.com/en-gb/excel-help/differences-between-the-opendocument-spreadsheet-ods-format-and-the-excel-xlsx-format-HA010355787.aspx Office.com - Differences between the OpenDocument Spreadsheet (.ods) format and the Excel (.xlsx) format]

=== Microsoft Office 2007 SP2 ===

When creating ODS spreadsheet files "vanilla" Microsoft Excel 2007 SP2 places spreadsheet formulae in the Excel namespace. The namespace it uses is different to that used by other applications such as OpenOffice.org use and is not the ODF 1.2 namespace nor the OOXML namespace. Applications that check the namespace will not read ODS files created with MS Excel 2007 SP2 when they include this feature or, if they are able to render the files at all, they will not be able to interpret the formulae correctly. This can cause such files to be displayed with corruption by other spreadsheet programs.

=== Microsoft Office 2010 ===

Microsoft Office 2010 also seems to have some issues adhering to the OpenDocument standard. See the following link for more information;

* [http://tbullock.comlore.com/2011/04/odf-12-support-in-microsoft-office.html Depth of Knowledge: ODF 1.2 Support in Microsoft Office]

== Software ==
LibreOffice ODF Validator [https://github.com/tdf/odftoolkit/tree/master/validator Repo] [https://tdf.github.io/odftoolkit/conformance/ODFValidator.html Website]

== Links ==
* [http://blog.riemann.cc/2013/04/23/versioning-of-openoffice-libreoffice-documents-using-git/ Versioning of OpenOffice/LibreOffice Documents Using Git]
* [https://blogs.msdn.microsoft.com/dmahugh/2009/05/05/odf-spreadsheet-interoperability/ ODF Spreadsheet Interoperability] (Microsoft discussion)

[[Category:XML based file formats]]
[[Category:ZIP based file formats]]

Just Solve the File Format Problem - User contributions [en]

OpenDocument

OpenDocument Spreadsheet