ISO/IEC 26300-2:2015Published

Information technology — Open Document Format for Office Applications (OpenDocument) v1.2 — Part 2: Recalculated Formula (OpenFormula) Format

Technologies de l'information — Format de document ouvert pour applications de bureau (OpenDocument) v1.2 — Partie 2: Format de formule (OpenFormula) recalculé

A new edition is under development: ISO/IEC PRF 26300-4.

Abstract / scope

ISO/IEC 26300-2:2015 the Open Document Format for Office Applications (OpenDocument) Version 1.2 specification. It defines a formula language for OpenDocument documents, which is also called OpenFormula.

OpenFormula is a specification of an open format for exchanging recalculated formulas between office applications, in particular, formulas in spreadsheet documents. OpenFormula defines data types, syntax, and semantics for recalculated formulas, including predefined functions and operations.

Using OpenFormula allows document creators to change the office application they use, exchange formulas with others (who may use a different application), and access formulas far in the future, with confidence that the recalculated formulas in their documents will produce equivalent results if given equivalent inputs.

OpenFormula is intended to be a supporting document to the Open Document Format for Office Applications (OpenDocument) format, particularly for defining its attributes table:formula and text:formula. It can also be used in other circumstances where a simple, easy-to-read infix text notation is desired for exchanging recalculated formulas.

Life cycle

Replaces

ISO/IEC 26300:2006PublishedInformation technology — Open Document Format for Office Applications (OpenDocument) v1.0International Standard · Published 30 Nov 2006 · ISO/IEC JTC 1/SC 34ISO/IEC 26300:2006/Cor 1:2010PublishedInformation technology — Open Document Format for Office Applications (OpenDocument) v1.0 — Technical Corrigendum 1International Standard · Published 15 Dec 2010 · ISO/IEC JTC 1/SC 34ISO/IEC 26300:2006/Cor 2:2011PublishedInformation technology — Open Document Format for Office Applications (OpenDocument) v1.0 — Technical Corrigendum 2International Standard · Published 30 Nov 2011 · ISO/IEC JTC 1/SC 34ISO/IEC 26300:2006/Amd 1:2012PublishedInformation technology — Open Document Format for Office Applications (OpenDocument) v1.0 — Amendment 1: Open Document Format for Office Applications (OpenDocument) v1.1International Standard · Published 8 Mar 2012 · ISO/IEC JTC 1/SC 34ISO/IEC 26300:2006/Amd 1:2012/Cor 1:2014PublishedInformation technology — Open Document Format for Office Applications (OpenDocument) v1.0 — Amendment 1: Open Document Format for Office Applications (OpenDocument) v1.1 — Technical Corrigendum 1International Standard · Published 14 Aug 2014 · ISO/IEC JTC 1/SC 34ISO/IEC 26300:2006/Cor 3:2014PublishedInformation technology — Open Document Format for Office Applications (OpenDocument) v1.0 — Technical Corrigendum 3International Standard · Published 14 Aug 2014 · ISO/IEC JTC 1/SC 34

Replaced by

ISO/IEC PRF 26300-4Under developmentInformation technology — Open document format for office applications (OpenDocument) version 1.3 — Part 4: Recalculated formula (OpenFormula) formatInternational Standard · ISO/IEC JTC 1