🔥🔥 Don’t Miss Out on Our End of Autumn Sale. If you have any questions, feel free to click the bottom right corner to contact our customer service..

Concat us[email protected]
Shopping Cart

No products in the cart.

🔍
BS ISO/IEC 26300-2:2015

BS ISO/IEC 26300-2:2015

$215.11

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

Published By Publication Date Number of Pages
BSI 2015 242
PDF Format Searchable Printable Preview Now
Guaranteed Safe Checkout
Categories: ,

If you have any questions, feel free to reach out to our online customer service team by clicking on the bottom right corner. We’re here to assist you 24/7.
Email:[email protected]

PDF Catalog

PDF Pages PDF Title
24 Blank Page
25 1 Introduction
1.1 Introduction
1.2 Terminology
1.3 Purpose
1.4 Normative References
26 1.5 Non-Normative References
27 2 Expressions and Evaluators
2.1 Introduction
2.2 OpenDocument Formula Expression
2.3 Evaluators
2.3.1 OpenDocument Formula Evaluator
2.3.2 OpenDocument Formula Small Group Evaluator
28 2.3.3 OpenDocument Formula Medium Group Evaluator
29 2.3.4 OpenDocument Formula Large Group Evaluator
30 2.4 Variances (Implementation-defined, Unspecified, and Behavioral Changes)
31 3 Formula Processing Model
3.1 General
3.2 Expression Evaluation
3.2.1 General
3.2.2 Expression Calculation
3.2.3 Operator and Function Evaluation
32 3.3 Non-Scalar Evaluation (aka ‘Array expressions’)
34 3.4 Host-Defined Behaviors
35 3.5 When recalculation occurs
3.6 Numerical Models
3.7 Basic Limits
37 4 Types
4.1 General
4.2 Text (String)
4.3 Number
4.3.1 General
38 4.3.2 Time
4.3.3 Date
4.3.4 DateTime
4.3.5 Percentage
4.3.6 Currency
4.3.7 Logical (Number)
39 4.4 Complex Number
4.5 Logical (Boolean)
4.6 Error
40 4.7 Empty Cell
4.8 Reference
4.9 ReferenceList
4.10 Array
41 4.11 Pseudotypes
4.11.1 General
4.11.2 Scalar
4.11.3 DateParam
4.11.4 TimeParam
4.11.5 Integer
4.11.6 TextOrNumber
4.11.7 Basis
4.11.7.1 General
42 4.11.7.2 Procedural Notation
4.11.7.3 Procedure A
4.11.7.4 Procedure B
43 4.11.7.5 Procedure C
4.11.7.6 Procedure D
4.11.7.7 Procedure E
4.11.7.8 Procedure F
4.11.8 Criterion
44 4.11.9 Database
4.11.10 Field
4.11.11 Criteria
45 4.11.12 Sequences (NumberSequence, NumberSequenceList, DateSequence, LogicalSequence, and ComplexSequence)
4.11.13 Any
46 5 Expression Syntax
5.1 General
5.2 Basic Expressions
47 5.3 Constant Numbers
5.4 Constant Strings
5.5 Operators
48 5.6 Functions and Function Parameters
49 5.7 Nonstandard Function Names
5.8 References
50 5.9 Reference List
5.10 Quoted Label
5.10.1 General
51 5.10.2 Lookup of Defined Labels
5.10.3 Automatic Lookup of Labels
52 5.10.4 Implicit Intersection
5.10.5 Automatic Range
53 5.10.6 Automatic Intersection
5.11 Named Expressions
54 5.12 Constant Errors
55 5.13 Inline Arrays
5.14 Whitespace
56 6 Standard Operators and Functions
6.1 General
6.2 Common Template for Functions and Operators
57 6.3 Implicit Conversion Operators
6.3.1 General
6.3.2 Conversion to Scalar
6.3.3 Implied intersection
6.3.4 Force to array context (ForceArray)
58 6.3.5 Conversion to Number
6.3.6 Conversion to Integer
6.3.7 Conversion to NumberSequence
59 6.3.8 Conversion to NumberSequenceList
6.3.9 Conversion to DateSequence
6.3.10 Conversion to Complex Number
6.3.11 Conversion to ComplexSequence
60 6.3.12 Conversion to Logical
6.3.13 Conversion to LogicalSequence
6.3.14 Conversion to Text
6.3.15 Conversion to DateParam
6.3.16 Conversion to TimeParam
61 6.4 Standard Operators
6.4.1 General
6.4.2 Infix Operator “+”
6.4.3 Infix Operator “-”
6.4.4 Infix Operator “*”
62 6.4.5 Infix Operator “/”
6.4.6 Infix Operator “^”
6.4.7 Infix Operator “=”
6.4.8 Infix Operator “”
63 6.4.9 Infix Operator Ordered Comparison (“<", "”, “>=”)
6.4.10 Infix Operator “&”
6.4.11 Infix Operator Reference Range (“:”)
64 6.4.12 Infix Operator Reference Intersection (“!”)
6.4.13 Infix Operator Reference Concatenation (“~”) (aka Union)
65 6.4.14 Postfix Operator “%”
6.4.15 Prefix Operator “+”
6.4.16 Prefix Operator “-”
66 6.5 Matrix Functions
6.5.1 General
6.5.2 MDETERM
6.5.3 MINVERSE
67 6.5.4 MMULT
6.5.5 MUNIT
6.5.6 TRANSPOSE
68 6.6 Bit operation functions
6.6.1 General
6.6.2 BITAND
6.6.3 BITLSHIFT
6.6.4 BITOR
69 6.6.5 BITRSHIFT
6.6.6 BITXOR
6.7 Byte-position text functions
6.7.1 General
6.7.2 FINDB
70 6.7.3 LEFTB
6.7.4 LENB
6.7.5 MIDB
6.7.6 REPLACEB
71 6.7.7 RIGHTB
6.7.8 SEARCHB
6.8 Complex Number Functions
6.8.1 General
6.8.2 COMPLEX
6.8.3 IMABS
72 6.8.4 IMAGINARY
6.8.5 IMARGUMENT
6.8.6 IMCONJUGATE
6.8.7 IMCOS
73 6.8.8 IMCOSH
6.8.9 IMCOT
6.8.10 IMCSC
6.8.11 IMCSCH
74 6.8.12 IMDIV
6.8.13 IMEXP
6.8.14 IMLN
6.8.15 IMLOG10
75 6.8.16 IMLOG2
6.8.17 IMPOWER
6.8.18 IMPRODUCT
6.8.19 IMREAL
76 6.8.20 IMSIN
6.8.21 IMSINH
6.8.22 IMSEC
6.8.23 IMSECH
77 6.8.24 IMSQRT
6.8.25 IMSUB
6.8.26 IMSUM
6.8.27 IMTAN
78 6.9 Database Functions
6.9.1 General
6.9.2 DAVERAGE
6.9.3 DCOUNT
6.9.4 DCOUNTA
79 6.9.5 DGET
6.9.6 DMAX
6.9.7 DMIN
6.9.8 DPRODUCT
80 6.9.9 DSTDEV
6.9.10 DSTDEVP
6.9.11 DSUM
6.9.12 DVAR
81 6.9.13 DVARP
6.10 Date and Time Functions
6.10.1 General
6.10.2 DATE
6.10.3 DATEDIF
82 6.10.4 DATEVALUE
6.10.5 DAY
6.10.6 DAYS
83 6.10.7 DAYS360
6.10.8 EDATE
84 6.10.9 EOMONTH
6.10.10 HOUR
6.10.11 ISOWEEKNUM
85 6.10.12 MINUTE
6.10.13 MONTH
6.10.14 NETWORKDAYS
86 6.10.15 NOW
6.10.16 SECOND
6.10.17 TIME
87 6.10.18 TIMEVALUE
6.10.19 TODAY
6.10.20 WEEKDAY
88 6.10.21 WEEKNUM
6.10.22 WORKDAY
89 6.10.23 YEAR
6.10.24 YEARFRAC
90 6.11 External Access Functions
6.11.1 General
6.11.2 DDE
6.11.3 HYPERLINK
91 6.12 Financial Functions
6.12.1 General
6.12.2 ACCRINT
92 6.12.3 ACCRINTM
6.12.4 AMORLINC
93 6.12.5 COUPDAYBS
6.12.6 COUPDAYS
94 6.12.7 COUPDAYSNC
6.12.8 COUPNCD
95 6.12.9 COUPNUM
96 6.12.10 COUPPCD
6.12.11 CUMIPMT
97 6.12.12 CUMPRINC
6.12.13 DB
98 6.12.14 DDB
100 6.12.15 DISC
6.12.16 DOLLARDE
6.12.17 DOLLARFR
101 6.12.18 DURATION
6.12.19 EFFECT
102 6.12.20 FV
6.12.21 FVSCHEDULE
6.12.22 INTRATE
103 6.12.23 IPMT
6.12.24 IRR
104 6.12.25 ISPMT
6.12.26 MDURATION
105 6.12.27 MIRR
6.12.28 NOMINAL
106 6.12.29 NPER
6.12.30 NPV
107 6.12.31 ODDFPRICE
6.12.32 ODDFYIELD
108 6.12.33 ODDLPRICE
6.12.34 ODDLYIELD
109 6.12.35 PDURATION
6.12.36 PMT
110 6.12.37 PPMT
6.12.38 PRICE
111 6.12.39 PRICEDISC
6.12.40 PRICEMAT
112 6.12.41 PV
6.12.42 RATE
113 6.12.43 RECEIVED
114 6.12.44 RRI
6.12.45 SLN
6.12.46 SYD
115 6.12.47 TBILLEQ
6.12.48 TBILLPRICE
116 6.12.49 TBILLYIELD
6.12.50 VDB
117 6.12.51 XIRR
6.12.52 XNPV
118 6.12.53 YIELD
6.12.54 YIELDDISC
119 6.12.55 YIELDMAT
6.13 Information Functions
6.13.1 General
6.13.2 AREAS
120 6.13.3 CELL
121 6.13.4 COLUMN
122 6.13.5 COLUMNS
6.13.6 COUNT
6.13.7 COUNTA
123 6.13.8 COUNTBLANK
6.13.9 COUNTIF
6.13.10 COUNTIFS
124 6.13.11 ERROR.TYPE
6.13.12 FORMULA
6.13.13 INFO
125 6.13.14 ISBLANK
126 6.13.15 ISERR
6.13.16 ISERROR
6.13.17 ISEVEN
6.13.18 ISFORMULA
127 6.13.19 ISLOGICAL
6.13.20 ISNA
6.13.21 ISNONTEXT
128 6.13.22 ISNUMBER
6.13.23 ISODD
6.13.24 ISREF
6.13.25 ISTEXT
129 6.13.26 N
6.13.27 NA
6.13.28 NUMBERVALUE
130 6.13.29 ROW
6.13.30 ROWS
6.13.31 SHEET
131 6.13.32 SHEETS
6.13.33 TYPE
132 6.13.34 VALUE
133 6.14 Lookup Functions
6.14.1 General
6.14.2 ADDRESS
134 6.14.3 CHOOSE
6.14.4 GETPIVOTDATA
135 6.14.5 HLOOKUP
136 6.14.6 INDEX
6.14.7 INDIRECT
137 6.14.8 LOOKUP
138 6.14.9 MATCH
139 6.14.10 MULTIPLE.OPERATIONS
140 6.14.11 OFFSET
141 6.14.12 VLOOKUP
6.15 Logical Functions
6.15.1 General
142 6.15.2 AND
6.15.3 FALSE
6.15.4 IF
6.15.5 IFERROR
143 6.15.6 IFNA
6.15.7 NOT
6.15.8 OR
144 6.15.9 TRUE
6.15.10 XOR
6.16 Mathematical Functions
6.16.1 General
6.16.2 ABS
145 6.16.3 ACOS
6.16.4 ACOSH
6.16.5 ACOT
6.16.6 ACOTH
146 6.16.7 ASIN
6.16.8 ASINH
6.16.9 ATAN
147 6.16.10 ATAN2
6.16.11 ATANH
6.16.12 BESSELI
148 6.16.13 BESSELJ
6.16.14 BESSELK
6.16.15 BESSELY
6.16.16 COMBIN
149 6.16.17 COMBINA
6.16.18 CONVERT
157 6.16.19 COS
6.16.20 COSH
158 6.16.21 COT
6.16.22 COTH
6.16.23 CSC
159 6.16.24 CSCH
6.16.25 DEGREES
6.16.26 DELTA
6.16.27 ERF
160 6.16.28 ERFC
6.16.29 EUROCONVERT
161 6.16.30 EVEN
162 6.16.31 EXP
6.16.32 FACT
6.16.33 FACTDOUBLE
6.16.34 GAMMA
163 6.16.35 GAMMALN
6.16.36 GCD
6.16.37 GESTEP
164 6.16.38 LCM
6.16.39 LN
6.16.40 LOG
6.16.41 LOG10
165 6.16.42 MOD
6.16.43 MULTINOMIAL
6.16.44 ODD
6.16.45 PI
166 6.16.46 POWER
6.16.47 PRODUCT
6.16.48 QUOTIENT
6.16.49 RADIANS
167 6.16.50 RAND
6.16.51 RANDBETWEEN
6.16.52 SEC
6.16.53 SERIESSUM
168 6.16.54 SIGN
6.16.55 SIN
169 6.16.56 SINH
6.16.57 SECH
6.16.58 SQRT
6.16.59 SQRTPI
170 6.16.60 SUBTOTAL
6.16.61 SUM
171 6.16.62 SUMIF
6.16.63 SUMIFS
172 6.16.64 SUMPRODUCT
6.16.65 SUMSQ
6.16.66 SUMX2MY2
6.16.67 SUMX2PY2
173 6.16.68 SUMXMY2
6.16.69 TAN
6.16.70 TANH
174 6.17 Rounding Functions
6.17.1 CEILING
6.17.2 INT
6.17.3 FLOOR
175 6.17.4 MROUND
6.17.5 ROUND
6.17.6 ROUNDDOWN
176 6.17.7 ROUNDUP
6.17.8 TRUNC
6.18 Statistical Functions
6.18.1 General
6.18.2 AVEDEV
177 6.18.3 AVERAGE
6.18.4 AVERAGEA
6.18.5 AVERAGEIF
178 6.18.6 AVERAGEIFS
6.18.7 BETADIST
179 6.18.8 BETAINV
6.18.9 BINOM.DIST.RANGE
180 6.18.10 BINOMDIST
6.18.11 LEGACY.CHIDIST
6.18.12 CHISQDIST
181 6.18.13 LEGACY.CHIINV
6.18.14 CHISQINV
6.18.15 LEGACY.CHITEST
182 6.18.16 CONFIDENCE
6.18.17 CORREL
183 6.18.18 COVAR
6.18.19 CRITBINOM
6.18.20 DEVSQ
184 6.18.21 EXPONDIST
6.18.22 FDIST
185 6.18.23 LEGACY.FDIST
6.18.24 FINV
6.18.25 LEGACY.FINV
186 6.18.26 FISHER
6.18.27 FISHERINV
6.18.28 FORECAST
187 6.18.29 FREQUENCY
6.18.30 FTEST
6.18.31 GAMMADIST
188 6.18.32 GAMMAINV
6.18.33 GAUSS
6.18.34 GEOMEAN
189 6.18.35 GROWTH
190 6.18.36 HARMEAN
6.18.37 HYPGEOMDIST
191 6.18.38 INTERCEPT
6.18.39 KURT
6.18.40 LARGE
192 6.18.41 LINEST
194 6.18.42 LOGEST
196 6.18.43 LOGINV
6.18.44 LOGNORMDIST
197 6.18.45 MAX
6.18.46 MAXA
6.18.47 MEDIAN
198 6.18.48 MIN
6.18.49 MINA
199 6.18.50 MODE
6.18.51 NEGBINOMDIST
6.18.52 NORMDIST
200 6.18.53 NORMINV
6.18.54 LEGACY.NORMSDIST
6.18.55 LEGACY.NORMSINV
201 6.18.56 PEARSON
6.18.57 PERCENTILE
202 6.18.58 PERCENTRANK
203 6.18.59 PERMUT
6.18.60 PERMUTATIONA
204 6.18.61 PHI
6.18.62 POISSON
6.18.63 PROB
205 6.18.64 QUARTILE
6.18.65 RANK
206 6.18.66 RSQ
207 6.18.67 SKEW
6.18.68 SKEWP
208 6.18.69 SLOPE
6.18.70 SMALL
209 6.18.71 STANDARDIZE
6.18.72 STDEV
6.18.73 STDEVA
210 6.18.74 STDEVP
6.18.75 STDEVPA
211 6.18.76 STEYX
6.18.77 LEGACY.TDIST
212 6.18.78 TINV
6.18.79 TREND
213 6.18.80 TRIMMEAN
6.18.81 TTEST
215 6.18.82 VAR
6.18.83 VARA
216 6.18.84 VARP
6.18.85 VARPA
217 6.18.86 WEIBULL
6.18.87 ZTEST
218 6.19 Number Representation Conversion Functions
6.19.1 General
6.19.2 ARABIC
219 6.19.3 BASE
6.19.4 BIN2DEC
6.19.5 BIN2HEX
220 6.19.6 BIN2OCT
6.19.7 DEC2BIN
221 6.19.8 DEC2HEX
6.19.9 DEC2OCT
222 6.19.10 DECIMAL
6.19.11 HEX2BIN
6.19.12 HEX2DEC
223 6.19.13 HEX2OCT
6.19.14 OCT2BIN
224 6.19.15 OCT2DEC
6.19.16 OCT2HEX
6.19.17 ROMAN
226 6.20 Text Functions
6.20.1 General
6.20.2 ASC
228 6.20.3 CHAR
6.20.4 CLEAN
229 6.20.5 CODE
6.20.6 CONCATENATE
6.20.7 DOLLAR
6.20.8 EXACT
230 6.20.9 FIND
6.20.10 FIXED
6.20.11 JIS
232 6.20.12 LEFT
233 6.20.13 LEN
6.20.14 LOWER
6.20.15 MID
234 6.20.16 PROPER
6.20.17 REPLACE
6.20.18 REPT
235 6.20.19 RIGHT
6.20.20 SEARCH
6.20.21 SUBSTITUTE
236 6.20.22 T
6.20.23 TEXT
6.20.24 TRIM
237 6.20.25 UNICHAR
6.20.26 UNICODE
6.20.27 UPPER
238 7 Other Capabilities
7.1 General
7.2 Inline constant arrays
7.3 Inline non-constant arrays
7.4 Year 1583
239 8 Non-portable Features
8.1 General
8.2 Distinct Logical

Related products

BS ISO/IEC 26300-2:2015
$215.11