Open Document Spreadsheet Excel

photo src: www.sidemcicek.com

The Open Document Format for Office Applications (ODF), also known as OpenDocument, is an XML-based file format for spreadsheets, charts, presentations and word processing documents. It was developed with the aim of providing an open, XML-based file format specification for office applications.

The standard was developed by a technical committee in the Organization for the Advancement of Structured Information Standards (OASIS) consortium. It was based on the Sun Microsystems specification for OpenOffice.org XML, the default format for OpenOffice.org, which had been specifically intended "to provide an open standard for office documents."

In addition to being an OASIS standard, it was published as an ISO/IEC international standard ISO/IEC 26300 - Open Document Format for Office Applications (OpenDocument).

photo src: libroediting.com

Maps, Directions, and Place Reviews

Specifications

The most common filename extensions used for OpenDocument documents are:

• .odt and .fodt for word processing (text) documents
• .ods and .fods for spreadsheets
• .odp and .fodp for presentations
• .odg and .fodg for graphics
• .odf for formulae, mathematical equations

The original OpenDocument format consists of an XML document that has <document> as its root element. OpenDocument files can also take the format of a ZIP compressed archive containing a number of files and directories; these can contain binary content and benefit from ZIP's lossless compression to reduce file size. OpenDocument benefits from separation of concerns by separating the content, styles, metadata, and application settings into four separate XML files.

There is a comprehensive set of example documents in OpenDocument format available. The whole test suite is available under the Creative Commons Attribution 2.5 license.

Open Document Spreadsheet Excel Video

Standardization

The OpenDocument standard was developed by a Technical Committee (TC) under the OASIS (Organization for the Advancement of Structured Information Standards) industry consortium. The ODF-TC has members from a diverse set of companies and individuals. Active TC members have voting rights. Members associated with Sun and IBM have sometimes had a large voting influence. The standardization process involved the developers of many office suites or related document systems. The first official ODF-TC meeting to discuss the standard was 16 December 2002; OASIS approved OpenDocument as an OASIS standard on 1 May 2005. OASIS submitted the ODF specification to ISO/IEC Joint Technical Committee 1 (JTC 1) on 16 November 2005, under Publicly Available Specification (PAS) rules. ISO/IEC standardization for an open document standard including text, spreadsheet and presentation was proposed for the first time in DKUUG 28 August 2001.

After a six-month review period, on 3 May 2006, OpenDocument unanimously passed its six-month DIS (Draft International Standard) ballot in JTC 1 (ISO/IEC JTC1/SC34), with broad participation, after which the OpenDocument specification was "approved for release as an ISO and IEC International Standard" under the name ISO/IEC 26300:2006.

After responding to all written ballot comments, and a 30-day default ballot, the OpenDocument international standard went to publication in ISO, officially published 30 November 2006.

Further standardization work with OpenDocument includes:

• The OASIS Committee Specification OpenDocument 1.0 (second edition) corresponds to the published ISO/IEC 26300:2006 standard. The content of ISO/IEC 26300 and OASIS OpenDocument v1.0 2nd ed. is identical. It includes the editorial changes made to address JTC1 ballot comments. It is available in ODF, HTML and PDF formats.
• OpenDocument 1.1 includes additional features to address accessibility concerns. It was approved as an OASIS Standard on 2007-02-01 following a call for vote issued on 2007-01-16. The public announcement was made on 2007-02-13. This version was not initially submitted to ISO/IEC, because it is considered to be a minor update to ODF 1.0 only, and OASIS were working already on ODF 1.2 at the time ODF 1.1 was approved. However it was later submitted to ISO/IEC (as of March 2011, it was in "enquiry stage" as Draft Amendment 1 - ISO/IEC 26300:2006/DAM 1) and published in March 2012 as "ISO/IEC 26300:2006/Amd 1:2012 - Open Document Format for Office Applications (OpenDocument) v1.1".
• OpenDocument 1.2 includes additional accessibility features, RDF-based metadata, a spreadsheet formula specification based on OpenFormula, support for digital signatures and some features suggested by the public. It consists of three parts: Part 1: OpenDocument Schema, Part 2: Recalculated Formula (OpenFormula) Format and Part 3: Packages. Version 1.2 of the specification was approved as an OASIS Standard on 29 September 2011. It was submitted to the relevant ISO committee under the Publicly Available Specification (PAS) procedure in March 2014. As of October 2014, it has been unanimously approved as a Draft International Standard, some comments have been raised in process that need to be addressed before OpenDocument 1.2 can proceed to become an International Standard. OpenDocument 1.2 was published as ISO/IEC standard on 17 June 2015.

Future

• OpenDocument 1.3 (a.k.a. "ODF-Next") As of January, 2014, the current state of a possible future version of OpenDocument specification is a working draft (a preliminary unapproved sketch, outline, or version of the specification). The OASIS Advanced Document Collaboration subcommittee (created in December, 2010) is working on an update of OpenDocument change-tracking that will not only enhance the existing change-tracking feature set, but also lay the foundation for the standardization of real-time collaboration by making change tracking compatible with real-time collaboration.

photo src: naturalbuffdog.com

Application support

Software

The OpenDocument format is used in free software and in proprietary software. This includes office suites (both stand-alone and web-based) and individual applications such as word-processors, spreadsheets, presentation, and data management applications. Prominent text editors, word processors and office suites supporting OpenDocument fully or partially include:

• AbiWord
• Adobe Buzzword
• Apache OpenOffice
• Atlantis Word Processor
• Bean (software)
• Calibre ebook viewer, converter, editor, and manager
• Calligra Suite
• Corel WordPerfect Office X6
• Evince
• Gnumeric
• Google Docs
• IBM Lotus Symphony
• Inkscape exports .odg
• KOffice
• LibreOffice
• Microsoft Office 2003 and Office XP (with the Open Source OpenXML/ODF Translator Add-in for Office)
• Microsoft Office 2007 (with Service Pack 2 or 3) supports ODF 1.1 (Windows only)
• Microsoft Office 2010 supports ODF 1.1 (Windows only)
• Microsoft Office 2013 supports ODF 1.2 (Windows only)
• Microsoft Office 2016 supports ODF 1.2 (Windows: read/write; OS X: read-only after online conversion)
• Microsoft OneDrive / Office Web Apps
• NeoOffice
• Okular
• ONLYOFFICE
• OpenOffice.org
• Scribus imports .odt and .odg
• SoftMaker Office
• SQL iQuery for IBM i (output support)
• Sun Microsystems StarOffice
• TextEdit
• WordPad 6.1 (Windows 7) partial support.
• Zoho Office Suite

Various organizations have announced development of conversion software (including plugins and filters) to support OpenDocument on Microsoft's products. As of July 2007, there are nine packages of conversion software. Microsoft first released support for the OpenDocument Format in Office 2007 SP2. However, the implementation faced substantial criticism and the ODF Alliance and others claimed that the third party plugins provided better support. Microsoft Office 2010 can open and save OpenDocument Format documents natively, although not all features are supported.

Starting with Mac OS X 10.5, the TextEdit application and Quick Look preview feature support the OpenDocument Text format.

Accessibility

photo src: naturalbuffdog.com

Licensing

Public access to the standard

Versions of the OpenDocument Format approved by OASIS are available for free download and use. The ITTF has added ISO/IEC 26300 to its "list of freely available standards"; anyone may download and use this standard free-of-charge under the terms of a click-through license.

Additional royalty-free licensing

Obligated members of the OASIS ODF TC have agreed to make deliverables available to implementors under the OASIS Royalty Free with Limited Terms policy.

Key contributor Sun Microsystems made an irrevocable intellectual property covenant, providing all implementers with the guarantee that Sun will not seek to enforce any of its enforceable U.S. or foreign patents against any implementation of the OpenDocument specification in which development Sun participates to the point of incurring an obligation.

A second contributor to ODF development, IBM - which, for instance, has contributed Lotus spreadsheet documentation - has made their patent rights available through their Interoperability Specifications Pledge in which "IBM irrevocably covenants to you that it will not assert any Necessary Claims against you for your making, using, importing, selling, or offering for sale Covered Implementations."

The Software Freedom Law Center has examined whether there are any legal barriers to the use of the OpenDocument Format (ODF) in free and open source software arising from the standardization process. In their opinion ODF is free of legal encumbrances that would prevent its use in free and open source software, as distributed under licenses authored by Apache and the FSF.

photo src: www.sidemcicek.com

Response

Support for OpenDocument

Several governments, companies, organizations and software products support the OpenDocument format. For example:

• The OpenDoc Society runs frequent ODF Plugfests in association with industry groups and Public Sector organisations. The 10th Plugfest was hosted by the UK Government Digital Service in conjunction with industry associations including the OpenForum Europe and OpenUK (formerly Open Source Consortium).
  • An output of the 10th Plugfest was an ODF toolkit which includes "Open Document Format principles for Government Technology" that has the purpose of simply explaining the case for ODF directed at the "average civil servant" and includes an extract from the UK Government policy relating to Open Document Format.
  • The toolkit also includes a single page graphical image designed to articulate the consequences of not choosing Open Document Format. The illustration has now been translated into more than 10 languages.
• Information technology companies like Apple Inc., Adobe Systems, Google, IBM, Intel, Microsoft, Nokia, Novell, Red Hat, Oracle as well as other companies who may or may not be working inside the OASIS OpenDocument Adoption Technical Committee.
• Over 600 companies and organizations promote OpenDocument format through The OpenDocument Format Alliance.
• NATO with its 26 members uses ODF as a mandatory standard for all members.
• The TAC (Telematics between Administrations Committee), composed of e-government policy-makers from the 25 European Union Member States, endorsed a set of recommendations for promoting the use of open document formats in the public sector.
• The free office suites Apache OpenOffice, Calligra, KOffice, NeoOffice and LibreOffice all use OpenDocument as their default file format.
• Several organisations, such as the OpenDocument Fellowship and OpenDoc Society were founded to support and promote OpenDocument.
• The UK government has adopted ODF as the standard for all documents in the UK civil service
• The Wikimedia Foundation supports ODF export from MediaWiki, which powers Wikipedia and a number of other Internet wiki-based sites.
• The default text processing applications in Windows 10 (WordPad) and Mac OS 10.9 (TextEdit) support OpenDocument Text.

On 4 November 2005, IBM and Sun Microsystems convened the "OpenDocument (ODF) Summit" in Armonk, New York, to discuss how to boost OpenDocument adoption. The ODF Summit brought together representatives from several industry groups and technology companies, including Oracle, Google, Adobe, Novell, Red Hat, Computer Associates, Corel, Nokia, Intel, and Linux e-mail company Scalix (LaMonica, 10 November 2005). The providers committed resources to technically improve OpenDocument through existing standards bodies and to promote its usage in the marketplace, possibly through a stand-alone foundation. Scholars have suggested that the "OpenDocument standard is the wedge that can hold open the door for competition, particularly with regard to the specific concerns of the public sector." Indeed, adoption by the public sector has risen considerably since the promulgation of the OpenDocument format initiated the 2005/2006 time period.

• Different applications using ODF as a standard document format have different methods of providing macro/scripting capabilities. There is no macro language specified in ODF. Users and developers differ on whether inclusion of a standard scripting language would be desirable.
• The ODF specification for tracked changes is limited and does not fully specify all cases, resulting in implementation-specific behaviors. In addition, OpenDocument does not support change tracking in elements like tables or MathML.
• It is not permitted to use generic ODF formatting style elements (like font information) for the MathML elements.

photo src: yaruki-up.info

Adoption

One objective of open formats like OpenDocument is to guarantee long-term access to data without legal or technical barriers, and some governments have come to view open formats as a public policy issue. Several governments around the world have introduced policies of partial or complete adoption. What this means varies from case to case; in some cases, it means that the ODF standard has a national standard identifier; in some cases, it means that the ODF standard is permitted to be used where national regulation says that non-proprietary formats must be used, and in still other cases, it means that some government body has actually decided that ODF will be used in some specific context. The following is an incomplete list:

Source of the article : Wikipedia