THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
| Topic | Developer | Status | BZ ID / Git commit | Comment | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
Basic Expressions 5.2 Office-3667 |
| Part of the basic expression BNF changed from: FunctionName Whitespace* '(' ParameterList ')' | to: FunctionName '(' ParameterList ')' | so whitespace is no longer valid between FunctionName and its bracketed parameter list. | ||||||||||
Criterion 4.11.8 Office-3766 | Damjan Jovanovic |
| Changes some references within the specification, but no change in meaning. | |||||||||
Sequences 4.11.12 Office-4003 |
| Changes "shall" to "must" in row/column processing order. |
Functions - Changed
| Topic | Developer | Status | BZ ID / Git commit | Comment | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Damjan Jovanovic |
| Changes the type of first argument from Integer to Number. We already use Number. | ||||||||||
| Damjan Jovanovic |
| Changes the type of first argument from Integer to Number. We already use Number. | ||||||||||
| Damjan Jovanovic |
| Changes the type of first argument from Integer to Number. We already use Number. | ||||||||||
| Damjan Jovanovic |
| Changes the type of first argument from Integer to Number. We already use Number. | ||||||||||
CELL 6.13.3 Office-3909 |
| |||||||||||
COVAR 6.18.18 Office-3757 | Damjan Jovanovic |
| Fixes the formula for covariance, adding the 1/N factor that was missing. We already use it. | |||||||||
CRITBINOM 6.18.19 Office-3921 | Damjan Jovanovic |
| Requires that 0 <= Alpha <= 1 instead of the wrong Alpha >= 1 in ODF 1.2. We already require that in our ScInterpreter::ScCritBinom() function, which does: if (n < 0.0 || alpha <= 0.0 || alpha >= 1.0 || p < 0.0 || p > 1.0) PushIllegalArgument(); Actually, strictly speaking, we require 0 < Alpha < 1, not 0 <= Alpha <= 1, but that's what Excel requires too, so let's leave it as is. Maybe we should report that issue back to OASIS? | |||||||||
DAYS360 6.10.7 Office-3907 |
| |||||||||||
DCOUNT 6.9.3 Office-3906 |
| |||||||||||
DCOUNTA 6.9.4 Office-3906 |
| |||||||||||
FLOOR 6.17.3 Office-3879 |
| |||||||||||
| ||||||||||||
HLOOKUP 6.14.5 Office-3902 |
| |||||||||||
| ||||||||||||
ISBLANK 6.13.14 Office-4000 | Damjan Jovanovic |
| 118236 | Updates documentation, adding "This function does not propagate Error values." We already do that. | ||||||||
ISFORMULA 6.13.18 Office-4000 |
| 118236 | Updates documentation, adding "This function does not propagate Error values." We already do that. | |||||||||
ISLOGICAL 6.13.19 Office-4000 | Damjan Jovanovic |
| 118236 | Updates documentation, adding "This function does not propagate Error values." We already do that. | ||||||||
ISNONTEXT 6.13.21 Office-4000 | Damjan Jovanovic |
| 118236 | Updates documentation, adding "This function does not propagate Error values." We already do that. | ||||||||
ISNUMBER 6.13.22 Office-4000 | Damjan Jovanovic |
| 118236 | Updates documentation, adding "This function does not propagate Error values." We already do that. | ||||||||
ISREF 6.13.24 Office-4000 | Damjan Jovanovic |
| 118236 | Updates documentation, adding "This function does not propagate Error values." We already do that. | ||||||||
ISTEXT 6.13.25 Office-4000 | Damjan Jovanovic |
| 118236 | Updates documentation, adding "This function does not propagate Error values." We already do that. | ||||||||
LINEST 6.18.41 Office-3902, Office-3948 |
| |||||||||||
LOGEST 6.18.42 Office-3902 |
| |||||||||||
MATCH 6.14.9 Office-3902 |
| |||||||||||
RECEIVED 6.12.43 Office-3916 |
| |||||||||||
STDEVP 6.18.74 Office-3856 | Damjan Jovanovic |
| Adds a constraint that mandates a sample size of at least 1 element, which we already require. | |||||||||
STDEVPA 6.18.75 Office-3856 | Damjan Jovanovic |
| Adds a constraint that mandates a sample size of at least 1 element, which we already require. | |||||||||
TYPE 6.13.33 Office-4000 | Damjan Jovanovic |
| 118236 | Updates documentation, adding "This function does not propagate Error values." We already do that. | ||||||||
VARPA 6.18.85 Office-3856 | Damjan Jovanovic |
| Adds a constraint that mandates a sample size of at least 1 element, which we already require. | |||||||||
VLOOKUP 6.14.12 Office-3902 |
| |||||||||||
WEEKDAY 6.10.20 Office-3908 |
| Needs to support new parameter values. |
...