OpenDocument Spreadsheet
(added LibreOffice Validator) |
|||
| (17 intermediate revisions by 5 users not shown) | |||
| Line 1: | Line 1: | ||
| − | + | {{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 == |
| − | * [[ODS files created by Microsoft Office 2010]] | + | |
| + | * [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]] | ||
Latest revision as of 08:17, 3 February 2024
The OpenDocument Spreadsheet format is one of a number of types of the 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.
Contents |
[edit] Information
- OpenDocument v1.0 specification
- OpenDocument v1.1 specification
- OpenDocument v1.2 specification
- Wikipedia - OpenDocument
[edit] 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:
- ODF Spreadsheet Interoperability: Theory and Practice
- Update on ODF Spreadsheet Interoperability
- A follow-up on Excel 2007 SP2′s ODF support
Doug Mahugh's response to Rob's posts may also contain some useful information:
Finally, Office.com has some information on the difference between their Office Open XML Spreadsheet format and OpenDocument Spreadsheet.
[edit] 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.
[edit] Microsoft Office 2010
Microsoft Office 2010 also seems to have some issues adhering to the OpenDocument standard. See the following link for more information;
[edit] Software
LibreOffice ODF Validator Repo Website
[edit] Links
- Versioning of OpenOffice/LibreOffice Documents Using Git
- ODF Spreadsheet Interoperability (Microsoft discussion)
