ISO/IEC 26300-2:2015

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

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.

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

General Information

• Status: Published
• Publication Date: 16-Jun-2015
• ICS: 35.240.30 - IT applications in information, documentation and publishing
• Technical Committee: ISO/IEC JTC 1/SC 34 - Document description and processing languages
• Drafting Committee: ISO/IEC JTC 1/SC 34 - Document description and processing languages

Relations

• Revises: ISO/IEC 26300:2006 - Information technology — Open Document Format for Office Applications (OpenDocument) v1.0
• Effective Date: 12-Apr-2014
• Revises: ISO/IEC 26300:2006/Amd 1:2012 - Information technology — Open Document Format for Office Applications (OpenDocument) v1.0 — Amendment 1: Open Document Format for Office Applications (OpenDocument) v1.1
• Effective Date: 12-Apr-2014

Standards Content (Sample)

INTERNATIONAL ISO/IEC
STANDARD 26300-2
First edition
2015-07-01

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é




Reference number
ISO/IEC 26300-2:2015(E)
©
ISO/IEC 2015

---------------------- Page: 1 ----------------------
ISO/IEC 26300-2:2015(E)

COPYRIGHT PROTECTED DOCUMENT


©  ISO/IEC 2015
All rights reserved. Unless otherwise specified, no part of this publication may be reproduced or utilized otherwise in any form or by any
means, electronic or mechanical, including photocopying, or posting on the internet or an intranet, without prior written permission.
Permission can be requested from either ISO at the address below or ISO’s member body in the country of the requester.
ISO copyright office
Case postale 56  CH-1211 Geneva 20
Tel. + 41 22 749 01 11
Fax + 41 22 749 09 47
E-mail [e-mail]
Web www.iso.org
Published in Switzerland

ii © ISO/IEC 2015 – All rights reserved

---------------------- Page: 2 ----------------------
ISO/IEC 26300-2:2015(E)
Foreword
ISO (the International Organization for Standardization) and IEC (the International Electrotechnical
Commission) form the specialized system for worldwide standardization. National bodies that are members of
ISO or IEC participate in the development of International Standards through technical committees
established by the respective organization to deal with particular fields of technical activity. ISO and IEC
technical committees collaborate in fields of mutual interest. Other international organizations, governmental
and non-governmental, in liaison with ISO and IEC, also take part in the work. In the field of information
technology, ISO and IEC have established a joint technical committee, ISO/IEC JTC 1.
The procedures used to develop this document and those intended for its further maintenance are described
in the ISO/IEC Directives, Part 1. In particular the different approval criteria needed for the different types of
document should be noted. This document was drafted in accordance with the editorial rules of the
ISO/IEC Directives, Part 2 (see www.iso.org/directives).
Attention is drawn to the possibility that some of the elements of this document may be the subject of patent
rights. ISO and IEC shall not be held responsible for identifying any or all such patent rights. Details of any
patent rights identified during the development of the document will be in the Introduction and/or on the ISO
list of patent declarations received (see www.iso.org/patents).
Any trade name used in this document is information given for the convenience of users and does not
constitute an endorsement.
For an explanation on the meaning of ISO specific terms and expressions related to conformity assessment,
as well as information about ISO's adherence to the WTO principles in the Technical Barriers to Trade (TBT),
see the following URL: Foreword — Supplementary information.
ISO/IEC 26300-2:2015 was prepared by the OASIS OpenDocument Technical Committee [as OASIS Open
Document Format for Office Applications (OpenDocument) v1.0 (second edition)] and was adopted, under the
PAS procedure, by Joint Technical Committee ISO/IEC JTC 1, Information technology, in parallel with its
approval by the national bodies of ISO and IEC. The content of ISO/IEC 26300-2 and OASIS OpenDocument
v1.0 2nd ed. is identical.
ISO/IEC 26300-2 consists of the following parts, under the general title Information technology — Open
Document Format for Office Applications (OpenDocument) v1.2:
— Part 1: OpenDocument Schema
— Part 3: Packages

© ISO/IEC 2015 – All rights reserved iii

---------------------- Page: 3 ----------------------
ISO/IEC 26300-2:2015(E)
Open Document Format for Office
Applications (OpenDocument)
Version 1.2
Part 2: Recalculated Formula (OpenFormula)
Format
OASIS Standard
29 September 2011
Specification URIs:
This version:
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.odt (Authoritative)
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.pdf
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html
Previous version:
http://docs.oasis-open.org/office/v1.2/csd06/OpenDocument-v1.2-csd06-part2.odt
(Authoritative)
http://docs.oasis-open.org/office/v1.2/csd06/OpenDocument-v1.2-csd06-part2.pdf
http://docs.oasis-open.org/office/v1.2/csd06/OpenDocument-v1.2-csd06-part2.html
Latest version:
http://docs.oasis-open.org/office/v1.2/OpenDocument-v1.2-part2.odt (Authoritative)
http://docs.oasis-open.org/office/v1.2/OpenDocument-v1.2-part2.pdf
http://docs.oasis-open.org/office/v1.2/OpenDocument-v1.2-part2.html
Technical Committee:
OASIS Open Document Format for Office Applications (OpenD
...