OpenDocument Format |
---|
This is an overview of software support for the OpenDocument format, an open document file format for saving and exchanging editable office documents.
The list here is not exhaustive.
A number of applications support the OASIS Open Document Format for Office Applications; listed alphabetically they include:
There are OpenDocument-oriented libraries available for languages such as Java, Python, Ruby, C++ and C#. OpenDoc Society maintains an extensive list of ODF software libraries for OpenDocument Format.
OpenDocument packages are ordinary zip files. There is an OpenDocument format which is just a single XML file, but most applications use the package format. Thus, any of the vast number of tools for handling zip files and XML data can be used to handle OpenDocument. Nearly all programming languages have libraries (built-in or available) for processing XML files and zip files.
Microsoft has been offering native support for ODF since Office 2007 Service Pack 2. [62] Microsoft is hosting the 8th ODF Plugfest in Brussels in 2012.
In October 2005, one year before the Microsoft Office 2007 suite was released, Microsoft declared that there is not sufficient demand from Microsoft customers for international standard OpenDocument format support and therefore it will not be included in Microsoft Office 2007. This statement was repeated also in next months. [63] [64] [65] [66] As an answer, on 20 October 2005 an online petition was created to demand ODF support from Microsoft. [67] The petition was signed by circa 12000 people. [68]
In May 2006, ODF plugin for Microsoft Office was released by OpenDocument Foundation. [69] Microsoft declared that the company did not work with the developers of the plug-in. [70]
In July 2006 Microsoft announced the creation of the Open XML Translator project—tools to build a technical bridge between the Microsoft Office Open XML Formats and the OpenDocument Format (ODF). This work was started in response to government requests for interoperability with ODF. The goal of project is not to implement ODF direct to Microsoft Office, but only to create plugin and external tools. [71] [72] In February 2007, this project released first version of ODF plug-in for Microsoft Word. [73]
In February 2007 SUN released initial version of SUN ODF plugin for Microsoft Office. [74] Version 1.0 was released in July 2007. [75]
Microsoft Office 2007 Service Pack 2 was released on 28 April 2009. [76] It added native support of OpenDocument 1.1 as well as other formats like XPS and PDF. [77] [78]
In April 2012, Microsoft announced support for ODF 1.2 in Microsoft Office 2013. [79] Microsoft Office 2021 supports ODF 1.3 [12] (Windows and MacOS).
Microsoft has financed the creation of an Open XML translator, [80] to enable the conversion of documents between Office Open XML and OpenDocument. The project, hosted on SourceForge, is an effort by several of Microsoft's partners to create a plugin for Microsoft Office that will be freely available under a BSD license. By December 2007, plugins had been released for Microsoft Word, Microsoft Excel and Microsoft PowerPoint. Independent analysis has, however, reported several concerns with these plugins, including lack of support for Office 2007. [81]
Sun Microsystems' ODF Plugin for Microsoft Office users [82] (download link no longer available as of 30 March 2013)— was a plugin that allowed users to read and edit ISO-standard Open Document Format (ODF) files in Microsoft Office. It works with Microsoft Office 2007 (with service pack 1 or higher), Microsoft Office 2003, Microsoft Office XP, and even Microsoft Office 2000. [83] [84]
ooo-word-filter [85] was a plugin that allowed users to open ODF files in Microsoft Office 2003.
OpenOpenOffice (O3), [86] is apparently inactive. OpenOpenOffice was developed by Phase-n, a free and open source software plug-in to enable Microsoft Office to read and write OpenDocument files (and any other formats supported by OpenOffice.org). Instead of installing a complete office application or even a large plug-in, O3 intended to install a tiny plug-in to the Microsoft Office system. This tiny plug-in intended to automatically send the file to some server, which would then do the conversion, returning the converted file. The server could be local to an organization (so private information doesn't go over the Internet) or accessed via the Internet (for those who do not want to set up a server). A beta of the server half has been completed, and further expected announcements have not occurred. Phase-n argued that the main advantage of their approach is simplicity. Their website [87] announces that O3 "requires no new concepts to be explored, no significant development, and leverages the huge existing body of work already created by the OpenOffice developers, the CPAN module authors, and the Microsoft .NET and Office teams. They also argue that this approach significantly simplifies maintenance; when a new version of OpenOffice is released, only the server needs to be upgraded.
The OpenDocument Foundation announced plans to develop a plugin for Microsoft Office in May 2006 [88] but development was stopped in October 2007. [89]
Microsoft supports OpenDocument format in Office 2007 SP2. [90] The current implementation faces criticism for not supporting encrypted documents and formula format in the same way as other OpenDocument compatible software, as well as for stripping out formulas in imported spreadsheets created by other OpenDocument compatible software. [91] [92] Critics say that with this conflict of standards Microsoft actually managed to reduce interoperability between office productivity software. [44] [92] [93] The company had previously reportedly stated that "where ODF 1.1 is ambiguous or incomplete, the Office implementation can be guided by current practice in OpenOffice.org, mainly, and other implementations including KOffice and AbiWord. Peter Amstein and the Microsoft Office team are reluctant to make liberal use of extension mechanisms, even though provided in ODF 1.1. They want to avoid all appearance of an embrace-extend attempt." [94] However, according to the ODF Alliance, "ODF spreadsheets created in Excel 2007 SP2 do not in fact conform to ODF 1.1 because Excel 2007 incorrectly encodes formulas with cell addresses. Section 8.3.1 of ODF 1.1 says that addresses in formulas "start with a "[" and end with a "]"." In Excel 2007, cell addresses were not enclosed with the necessary square brackets, which could be easily corrected." [95] This however has been contested as the ISO/IEC 26300 specification states that the semantics and the syntax is dependent on the used namespace which is implementation dependent leaving the syntax implementation defined as well. [96]
Before SP2, Microsoft had sponsored the creation of the Open XML translator [80] project to allow the conversion of documents between OOXML and OpenDocument. As a result of this project, Microsoft financed the ODF add-in for Word project on SourceForge. This project is an effort by several of Microsoft's partners to create a plugin for Microsoft Office that will be freely available under a BSD license. The project released version 1.0 for Microsoft Word of this software in January 2007 followed by versions for Microsoft Excel and Microsoft PowerPoint in December of the same year. Sun Microsystems has created the competing OpenDocument plugin for Microsoft Office 2007 (Service Pack 1 or higher), 2000, XP, and 2003 that supports Word, Excel, and PowerPoint documents. [84] The ODF Alliance has claimed that third-party plug-ins "provide better support for ODF than the recently released Microsoft Office 2007 SP2". [97]
One important issue raised in the discussion of OpenDocument is whether the format is accessible to those with disabilities. There are two issues: does the specification support accessibility, and are implementations accessible?
While the specification of OpenDocument is going through an extensive accessibility review, many of the components it is built on (such as SMIL for audio and multimedia and SVG for vector graphics) have already gone through the World Wide Web Consortium (W3C)'s Web Accessibility Initiative processes.
There are already applications that currently read/write OpenDocument that export Tagged PDF files (to support PDF accessibility); this suggests that much or all of the necessary data for accessibility is already included in the OpenDocument format.
The OASIS OpenDocument technical committee released a draft of OpenDocument 1.1 on 27 July 2006, for public comment through 25 September 2006. [98] This is a minor update to the specification to add accessibility information, mainly soft page break markings, table header markings, presentation navigation markings, alternative text and captions, and specifically stating that spreadsheets may be embedded in presentations. Peter Korn (an accessibility expert) reviewed version 1.1 "to satisfy myself that all of our accessibility concerns have been addressed", and declared "I am so satisfied." [99] [100]
Peter Korn gave an in-depth report [101] on OpenDocument accessibility. He noted that there are many kinds of impairments, including visual (minor, major, or blind), physical (minor, major with vocal control, major without vocal control), auditory, and cognitive. He then noted that the situation varies, depending on the specific disability. For a vast number of disabilities, there are no known problems, though.
Since OpenDocument is an Open Standard file format, there is no need for everyone to use the same program to read and write OpenDocument files; someone with a disability is free to use whatever program works best for them.
Microsoft Word is a word processor program developed by Microsoft. It was first released on October 25, 1983, under the name Multi-Tool Word for Xenix systems. Subsequent versions were later written for several other platforms including: IBM PCs running DOS (1983), Apple Macintosh running the Classic Mac OS (1985), AT&T UNIX PC (1985), Atari ST (1988), OS/2 (1989), Microsoft Windows (1989), SCO Unix (1990), macOS (2001), Web browsers (2010), iOS (2014) and Android (2015).
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.
Microsoft Works is a discontinued productivity software suite developed by Microsoft and sold from 1987 to 2009. Its core functionality includes a word processor, a spreadsheet and a database management system. Later versions have a calendar application and a dictionary while older releases include a terminal emulator. Works is available as a standalone program and as part of a namesake home productivity suite. Because of its low cost, companies frequently preinstalled Works on their low-cost machines. Works is smaller, less expensive, and has fewer features than contemporary major office suites such as Microsoft Office.
NeoOffice was an office suite for the macOS operating system developed by Planamesa Inc. It was a commercial fork of the free and open source LibreOffice office suite, including a word processor, spreadsheet, presentation program, and graphics program. It added some features not present in the macOS versions of LibreOffice and Apache OpenOffice. The last few versions were based on LibreOffice 4.4, which was released mid-2014.
The following tables compare general and technical information for a number of office suites:
Microsoft Office 2007 is an office suite for Windows, developed and published by Microsoft. It was officially revealed on March 9, 2006 and was the 12th version of Microsoft Office. It was released to manufacturing on November 3, 2006; it was subsequently made available to volume license customers on November 30, 2006, and later to retail on January 30, 2007. The Mac OS X equivalent, Microsoft Office 2008 for Mac, was released on January 15, 2008.
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.
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.
Uniform Office Format, sometimes known as Unified Office Format, is an open standard for office applications developed in China. It includes word processing, presentation, and spreadsheet modules, and is made up of GUI, API, and format specifications. The document format described uses XML contained in a compressed file container, similar to OpenDocument and Office Open XML.
IBM Lotus Symphony is a discontinued suite of applications for creating, editing, and sharing text, spreadsheet, presentations, and other documents and browsing the World Wide Web. It was first distributed as commercial proprietary software, then as freeware, before IBM contributed the suite to the Apache Software Foundation in 2014 for inclusion in the free and open-source Apache OpenOffice software suite.
Go-oo is a discontinued free office suite which started as a set of patches for OpenOffice.org, then later became an independent fork of OpenOffice.org with a number of enhancements, sponsored by Novell.
The Office Open XML format (OOXML), is an open and free document file format for saving and exchanging editable office documents such as text documents, spreadsheets, charts, and presentations.
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.
Xena is open-source software for use in digital preservation. Xena is short for XML Electronic Normalising for Archives.
LibreOffice Writer is the free and open-source word processor and desktop publishing component of the LibreOffice software package and is a fork of OpenOffice.org Writer. Writer is a word processor similar to Microsoft Word and Corel's WordPerfect with many similar features, and file format compatibility.
LibreOffice Calc is the spreadsheet component of the LibreOffice software package.
Collabora Online is an open source online office suite based on LibreOffice, enabling web-based collaborative real-time editing of word processing documents, spreadsheets, presentations, and vector graphics. Optional apps are available for desktops, laptops, tablets, smartphones, and Chromebooks.
A test spreadsheet created in Google Docs, KSpread, Symphony, OpenOffice, and the Sun Plug-In 3.0 for MS Office, for example, when loaded in MS Excel 2007, failed to process correctly. This is because the formulas used to perform calculations within a spreadsheet (e.g., adding numbers in a column of cells) are simply removed in MS Excel 2007. Instead of performing the calculations, what is left is when the spreadsheet is loaded in MS Excel 2007 is the last value that cell had, when previously saved. The same test spreadsheet, when loaded and saved in all the other applications besides MS Excel 2007 (e.g., between KSpread and Google Docs), does process correctly. Most other ODF spreadsheet applications are able to interoperate just fine. The correct approach would have been for Microsoft to do the same to ensure that MS Office users can share spreadsheets with other ODF-supporting office suites.
Yet Microsoft Office SP2 claims to have a fully compliant version of ODF, and that's probably true, as defined by the specification. It's just completely useless at interoperating with other vendors' products. This is not interoperability, it's an attack on the very concept.
ODF spreadsheets created in Excel 2007 SP2 do not in fact conform to ODF 1.1 because Excel 2007 incorrectly encodes formulas with cell addresses. Section 8.3.1 of ODF 1.1 says that addresses in formulas "start with a "[" and end with a "]"." In Excel 2007 cell addresses were not enclosed with the necessary square brackets, which could be easily corrected.
MS Excel 2007 will process ODF spreadsheet documents when loaded via the Sun Plug-In 3.0 for MS Office or the SourceForge "OpenXML/ODF Translator Add-in for Office," but will fail when using the "built-in" support provided by Office 2007 SP2.