1、BSI Standards Publication BS ISO/IEC 26300-2:2015 Information technology Open Document Format for Office Applications (OpenDocument) v1.2 Part 2: Recalculated Formula (OpenFormula) FormatBS ISO/IEC 26300-2:2015 BRITISH STANDARD National foreword This British Standard is the UK implementation of ISO/
2、IEC 26300-2:2015. Together with BS ISO/IEC 26300-1:2015 and BS ISO/IEC 26300-3:2015 it supersedes BS ISO/IEC 26300:2006+A1:2012, which is withdrawn. The UK participation in its preparation was entrusted to Technical Committee IST/41, Document description and processing language. A list of organizati
3、ons represented on this committee can be obtained on request to its secretary. This publication does not purport to include all the necessary provisions of a contract. Users are responsible for its correct application. The British Standards Institution 2015. Published by BSI Standards Limited 2015 I
4、SBN 978 0 580 86556 5 ICS 35.240.30 Compliance with a British Standard cannot confer immunity from legal obligations. This British Standard was published under the authority of the Standards Policy and Strategy Committee on 31 July 2015. Amendments/corrigenda issued since publication Date Text affec
5、tedInformation technology Open Document Format for Office Applications (OpenDocument) v1.2 Part 2: Recalculated Formula (OpenFormula) Format Technologies de linformation Format de document ouvert pour applications de bureau (OpenDocument) v1.2 Partie 2: Titre manque INTERNATIONAL STANDARD ISO/IEC 26
6、300-2 Reference number ISO/IEC 26300-2:2015(E) First edition 2015-07-01 ISO/IEC 2015 BS ISO/IEC 26300-2:2015ii ISO/IEC 2015 All rights reserved COPYRIGHT PROTECTED DOCUMENT ISO/IEC 2015 All rights reserved. Unless otherwise specified, no part of this publication may be reproduced or utilized otherwi
7、se 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 ISOs member body in the country of the requester. ISO copyright office Ca
8、se postale 56 CH-1211 Geneva 20 Tel. + 41 22 749 01 11 Fax + 41 22 749 09 47 E-mail copyrightiso.org Web www.iso.org Published in Switzerland ISO/IEC 26300-2:2015(E)BS ISO/IEC 26300-2:2015 Open Document Format for Office Applications (OpenDocument) Version 1.2 Part 2: Recalculated Formula (OpenFormu
9、la) 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-
10、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
11、:/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
12、 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 BS ISO/IEC 26300-2:2015 ISO/IEC 26300-2:2015(E)BS ISO/IEC 26300-2:2015 David A. Wheeler
13、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 O
14、penDocument 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
15、 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 revi
16、sions of this document. Technical Committee members should send comments on this specification to the Technical Committees email list. Others should send comments to the Technical Committee by using the “ Send A Comment” button on the Technical Committees web page at http:/www.oasis-open.org/committ
17、ees/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/committ
18、ees/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 Standar
19、d. 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 BS ISO/IEC 26300-2:2015 ISO/IEC 26300-2:2015(E)BS ISO/IEC 26300-2:2015 Notices
20、Copyright OASIS Open 20022011. 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
21、 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 inclu
22、ded 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
23、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
24、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 P
25、ARTICULAR 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 t
26、o 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 b
27、e 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 disclai
28、ms 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 mi
29、ght 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 a
30、vailable 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 O
31、ASIS 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
32、, 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
33、Work Product Page 3 of 234 BS ISO/IEC 26300-2:2015 ISO/IEC 26300-2:2015(E)BS ISO/IEC 26300-2:2015 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 Septem
34、ber 2011 Copyright OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product Page 4 of 234 BS ISO/IEC 26300-2:2015 ISO/IEC 26300-2:2015(E)BS ISO/IEC 26300-2:2015 Table of Contents 1 Introduction20 1.1 Introduction.20 1.2 Terminology.20 1.3 Purpose20 1.4 Normative References20 1.5 Non
35、-Normative References21 2 Expressions and Evaluators.22 2.1 Introduction.22 2.2 OpenDocument Formula Expression22 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 Form
36、ula Large Group Evaluator24 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 General26 3.2.2 Expression Calculation .26 3.2.3 Operator and Function Evaluation.26 3.3 Non-Scalar Evaluation (ak
37、a Array expressions)27 3.4 Host-Defined Behaviors29 3.5 When recalculation occurs30 3.6 Numerical Models.30 3.7 Basic Limits.30 4 Types32 4.1 General.32 4.2 Text (String)32 4.3 Number.32 4.3.1 General32 4.3.2 Time.33 4.3.3 Date.33 4.3.4 DateTime.33 OpenDocument-v1.2-os-part2 29 September 2011 Copyri
38、ght OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product Page 5 of 234 BS ISO/IEC 26300-2:2015 ISO/IEC 26300-2:2015(E)BS ISO/IEC 26300-2:2015 4.3.5 Percentage33 4.3.6 Currency33 4.3.7 Logical (Number).33 4.4 Complex Number34 4.5 Logical (Boolean)34 4.6 Error34 4.7 Empty Cell.35
39、4.8 Reference.35 4.9 ReferenceList35 4.10 Array.35 4.11 Pseudotypes.36 4.11.1 General36 4.11.2 Scalar.36 4.11.3 DateParam.36 4.11.4 TimeParam36 4.11.5 Integer36 4.11.6 TextOrNumber36 4.11.7 Basis36 4.11.8 Criterion.38 4.11.9 Database.39 4.11.10 Field.39 4.11.11 Criteria39 4.11.12 Sequences (NumberSe
40、quence, NumberSequenceList, DateSequence, LogicalSequence, and ComplexSequence)40 4.11.13 Any.40 5 Expression Syntax41 5.1 General.41 5.2 Basic Expressions.41 5.3 Constant Numbers42 5.4 Constant Strings.42 5.5 Operators42 5.6 Functions and Function Parameters.43 5.7 Nonstandard Function Names44 5.8
41、References.44 5.9 Reference List.45 5.10 Quoted Label45 5.10.1 General45 5.10.2 Lookup of Defined Labels46 OpenDocument-v1.2-os-part2 29 September 2011 Copyright OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product Page 6 of 234 BS ISO/IEC 26300-2:2015 ISO/IEC 26300-2:2015(E)BS
42、ISO/IEC 26300-2:2015 5.10.3 Automatic Lookup of Labels.46 5.10.4 Implicit Intersection47 5.10.5 Automatic Range.47 5.10.6 Automatic Intersection.48 5.11 Named Expressions48 5.12 Constant Errors.49 5.13 Inline Arrays50 5.14 Whitespace.50 6 Standard Operators and Functions51 6.1 General.51 6.2 Common
43、Template for Functions and Operators51 6.3 Implicit Conversion Operators.52 6.3.1 General52 6.3.2 Conversion to Scalar.52 6.3.3 Implied intersection52 6.3.4 Force to array context (ForceArray).52 6.3.5 Conversion to Number.53 6.3.6 Conversion to Integer53 6.3.7 Conversion to NumberSequence.53 6.3.8
44、Conversion to NumberSequenceList.54 6.3.9 Conversion to DateSequence54 6.3.10 Conversion to Complex Number54 6.3.11 Conversion to ComplexSequence54 6.3.12 Conversion to Logical55 6.3.13 Conversion to LogicalSequence55 6.3.14 Conversion to Text.55 6.3.15 Conversion to DateParam55 6.3.16 Conversion to
45、 TimeParam.55 6.4 Standard Operators56 6.4.1 General56 6.4.2 Infix Operator “+“.56 6.4.3 Infix Operator “-“56 6.4.4 Infix Operator “*“56 6.4.5 Infix Operator “/“57 6.4.6 Infix Operator “57 6.4.7 Infix Operator “=“.57 6.4.8 Infix Operator “=“).58 OpenDocument-v1.2-os-part2 29 September 2011 Copyright
46、 OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product Page 7 of 234 BS ISO/IEC 26300-2:2015 ISO/IEC 26300-2:2015(E)BS ISO/IEC 26300-2:2015 6.4.10 Infix Operator “&“.58 6.4.11 Infix Operator Reference Range (“:“).58 6.4.12 Infix Operator Reference Intersection (“!“).59 6.4.13 Inf
47、ix Operator Reference Concatenation (“) (aka Union)59 6.4.14 Postfix Operator “%“60 6.4.15 Prefix Operator “+“.60 6.4.16 Prefix Operator “-“60 6.5 Matrix Functions61 6.5.1 General61 6.5.2 MDETERM61 6.5.3 MINVERSE61 6.5.4 MMULT62 6.5.5 MUNIT.62 6.5.6 TRANSPOSE.62 6.6 Bit operation functions.63 6.6.1
48、General63 6.6.2 BITAND63 6.6.3 BITLSHIFT.63 6.6.4 BITOR63 6.6.5 BITRSHIFT64 6.6.6 BITXOR.64 6.7 Byte-position text functions.64 6.7.1 General64 6.7.2 FINDB64 6.7.3 LEFTB.65 6.7.4 LENB.65 6.7.5 MIDB65 6.7.6 REPLACEB65 6.7.7 RIGHTB.66 6.7.8 SEARCHB.66 6.8 Complex Number Functions.66 6.8.1 General66 6.
49、8.2 COMPLEX.66 6.8.3 IMABS.66 6.8.4 IMAGINARY.67 6.8.5 IMARGUMENT67 6.8.6 IMCONJUGATE.67 6.8.7 IMCOS.67 OpenDocument-v1.2-os-part2 29 September 2011 Copyright OASIS Open 2002 - 2011. All Rights Reserved. Standards Track Work Product Page 8 of 234 BS ISO/IEC 26300-2:2015 ISO/IEC 26300-2:2015(E)BS ISO/IEC 26300-2:2015 6.8.8 IMCOSH .68 6.8.9 IMCOT.68 6.8.10 IMCSC.68 6.8.11 IMCSCH.68 6.8.12 IMDIV.69 6.8.13 IMEXP.69 6.8.14 IMLN69 6.8.15 IMLOG10.69 6.8.16 IMLOG2.70 6.8.17 IMPOWER.70 6.8.18 IMPROD
