ISO/IEC 26300-2:2015

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 2015
©  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 copyright@iso.org
Web www.iso.org
Published in Switzerland
ii © ISO/IEC 2015 – All rights reserved

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.
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

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 (OpenDocument) TC
Chairs:
Rob Weir, IBM
Michael Brauer, Oracle Corporation
Editors:
OpenDocument-v1.2-os-part2 29 September 2011
Copyright © OASIS Open 2002 - 2011. All Rights Reserved.  Standards Track Work Product Page 1 of 234
© ISO/IEC 2015 – All rights reserved

David A. Wheeler
Patrick Durusau
Eike Rathke, Oracle Corporation
Rob Weir, IBM
Related work:
This document is part of the OASIS Open Document Format for Office Applications
(OpenDocument) Version 1.2 specification.
The OpenDocument v1.2 specification has these parts:
OpenDocument v1.2 part 1: OpenDocument Schema
OpenDocument v1.2 part 2: Recalculated Formula (OpenFormula) Format (this part)
OpenDocument v1.2 part 3: Packages
Declared XML namespaces:
None.
Abstract:
This document is part of the Open Document Format for Office Applications
(OpenDocument) Version 1.2 specification.
It defines a formula language to be used in OpenDocument documents.
Status:
This document was last revised or approved by the OASIS Open Document Format for
Office Applications (OpenDocument) TC on the above date. The level of approval is also
listed above. Check the "Latest version" location noted above for possible later revisions
of this document.
Technical Committee members should send comments on this specification to the
Technical Committee’s email list. Others should send comments to the Technical
Committee by using the “Send A Comment” button on the Technical Committee’s web
page at http://www.oasis-open.org/committees/office/.
For information on whether any patents have been disclosed that may be essential to
implementing this specification, and any offers of patent licensing terms, please refer to
the Intellectual Property Rights section of the Technical Committee web page
(http://www.oasis-open.org/committees/office/ipr.php).
Citation format:
When referencing this specification the following citation format should be used:
OpenDocument-v1.2-part2
Open Document Format for Office Applications (OpenDocument) Version 1.2 Part 2:
Recalculated Formula (OpenFormula) Format. 29 September 2011. OASIS Standard.
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html.
OpenDocument-v1.2-os-part2 29 September 2011
Copyright © OASIS Open 2002 - 2011. All Rights Reserved.  Standards Track Work Product Page 2 of 234
© ISO/IEC 2015 – All rights reserved

Notices
Copyright © OASIS Open 2002–2011. All Rights Reserved.
All capitalized terms in the following text have the meanings assigned to them in the OASIS
Intellectual Property Rights Policy (the "OASIS IPR Policy"). The full Policy may be found at the
OASIS website.
This document and translations of it may be copied and furnished to others, and derivative works
that comment on or otherwise explain it or assist in its implementation may be prepared, copied,
published, and distributed, in whole or in part, without restriction of any kind, provided that the
above copyright notice and this section are included on all such copies and derivative works.
However, this document itself may not be modified in any way, including by removing the copyright
notice or references to OASIS, except as needed for the purpose of developing any document or
deliverable produced by an OASIS Technical Committee (in which case the rules applicable to
copyrights, as set forth in the OASIS IPR Policy, must be followed) or as required to translate it
into languages other than English.
The limited permissions granted above are perpetual and will not be revoked by OASIS or its
successors or assigns.
This document and the information contained herein is provided on an "AS IS" basis and OASIS
DISCLAIMS ALL WARRANTIES, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO
ANY WARRANTY THAT THE USE OF THE INFORMATION HEREIN WILL NOT INFRINGE ANY
OWNERSHIP RIGHTS OR ANY IMPLIED WARRANTIES OF MERCHANTABILITY OR FITNESS
FOR A PARTICULAR PURPOSE.
OASIS requests that any OASIS Party or any other party that believes it has patent claims that
would necessarily be infringed by implementations of this OASIS Committee Specification or
OASIS Standard, to notify OASIS TC Administrator and provide an indication of its willingness to
grant patent licenses to such patent claims in a manner consistent with the IPR Mode of the
OASIS Technical Committee that produced this specification.
OASIS invites any party to contact the OASIS TC Administrator if it is aware of a claim of
ownership of any patent claims that would necessarily be infringed by implementations of this
specification by a patent holder that is not willing to provide a license to such patent claims in a
manner consistent with the IPR Mode of the OASIS Technical Committee that produced this
specification. OASIS may include such claims on its website, but disclaims any obligation to do
so.
OASIS takes no position regarding the validity or scope of any intellectual property or other rights
that might be claimed to pertain to the implementation or use of the technology described in this
document or the extent to which any license under such rights might or might not be available;
neither does it represent that it has made any effort to identify any such rights. Information on
OASIS' procedures with respect to rights in any document or deliverable produced by an OASIS
Technical Committee can be found on the OASIS website. Copies of claims of rights made
available for publication and any assurances of licenses to be made available, or the result of an
attempt made to obtain a general license or permission for the use of such proprietary rights by
implementers or users of this OASIS Committee Specification or OASIS Standard, can be
obtained from the OASIS TC Administrator. OASIS makes no representation that any information
or list of intellectual property rights will at any time be complete, or that any claims in such list are,
in fact, Essential Claims.
The names "OASIS", “OpenDocument”, “Open Document Format”, and “ODF” are trademarks of
OASIS, the owner and developer of this specification, and should be used only to refer to the
organization and its official outputs. OASIS welcomes reference to, and implementation and use
OpenDocument-v1.2-os-part2 29 September 2011
Copyright © OASIS Open 2002 - 2011. All Rights Reserved.  Standards Track Work Product Page 3 of 234
© ISO/IEC 2015 – All rights reserved

of, specifications, while reserving the right to enforce its marks against misleading uses. Please
see http://www.oasis-open.org/who/trademark.php for above guidance.
OpenDocument-v1.2-os-part2 29 September 2011
Copyright © OASIS Open 2002 - 2011. All Rights Reserved.  Standards Track Work Product Page 4 of 234
© ISO/IEC 2015 – All rights reserved

Table of Contents
1 Introduction. 20
1.1 Introduction.20
1.2 Terminology.20
1.3 Purpose.20
1.4 Normative References.20
1.5 Non-Normative References.21
2 Expressions and Evaluators.22
2.1 Introduction.22
2.2 OpenDocument Formula Expression.22
2.3 Evaluators.22
2.3.1 OpenDocument Formula Evaluator.22
2.3.2 OpenDocument Formula Small Group Evaluator.22
2.3.3 OpenDocument Formula Medium Group Evaluator.23
2.3.4 OpenDocument Formula Large Group Evaluator.24
2.4 Variances (Implementation-defined, Unspecified, and Behavioral Changes).25
3 Formula Processing Model.26
3.1 General. 26
3.2 Expression Evaluation.26
3.2.1 General.26
3.2.2 Expression Calculation .26
3.2.3 Operator and Function Evaluation.26
3.3 Non-Scalar Evaluation (aka 'Array expressions').27
3.4 Host-Defined Behaviors.
...