Topic | Developer | Status | BZ ID / Git commit | Comment |
---|
BESSELI 6.16.12 Office-3842 | Damjan Jovanovic | |
| Changes the type of first argument from Integer to Number. We already use Number. |
BESSELJ 6.16.13 Office-3842 | Damjan Jovanovic | |
| Changes the type of first argument from Integer to Number. We already use Number. |
BESSELK 6.16.14 Office-3842 | Damjan Jovanovic | |
| Changes the type of first argument from Integer to Number. We already use Number. |
BESSELY 6.16.15 Office-3842 | Damjan Jovanovic | |
| Changes the type of first argument from Integer to Number. We already use Number. |
CELL 6.13.3 Office-3909 | Damjan Jovanovic | |
| Changes the condition under which CELL("ADDRESS", ref) returns the sheet name, from "if given in the reference" to "if given in the reference and does not reference the same sheet as the sheet the expression is evaluated upon". Our CELL function already returns the sheet name under the new condition. |
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 | Damjan Jovanovic | |
| Changes parameter 3 (Method) from Integer to Logical. For us, it is already logical, method ScInterpreter::ScGetDiffDate360() does: sal_Bool bFlag; if (nParamCount == 3) bFlag = GetBool(); else bFlag = sal_False; |
DCOUNT 6.9.3 Office-3906 | Damjan Jovanovic | | 561c6157b86908803ccecf18699e7b5dfaba10b2 | The 2nd parameter, DatabaseField, is optional in ODF 1.3. |
DCOUNTA 6.9.4 Office-3906 | Damjan Jovanovic | | 561c6157b86908803ccecf18699e7b5dfaba10b2 | The 2nd parameter, DatabaseField, is optional in ODF 1.3. |
FLOOR 6.17.3 Office-3879 | Damjan Jovanovic | |
| Changes FLOOR() to round towards zero, like it should, instead of away from zero. We already do that. |
FTEST 6.18.30 Office-3903 |
| |
| Need to re-examine implementation. |
HLOOKUP 6.14.5 Office-3902 | Damjan Jovanovic | Status |
---|
| |
---|
colour | RedGreen |
---|
title | OPEN | CLOSED |
---|
|
| 07b7105f20776a1b6f4e27351365759551337431 | Changes parameter type to "ForceArray Reference|Array". |
IF 6.15.4 Office-3844 |
| |
| Needs to be able to handle missing "then" and "else" expressions, eg. IF(condition;), IF(condition;;) and IF(condition;IfTrue;) all give errors in AOO, but they shouldn't. |
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 |
| | 07b7105f20776a1b6f4e27351365759551337431 | For Office-3902, changes parameter type to "ForceArray". |
LOGEST 6.18.42 Office-3902 | Damjan Jovanovic | Status |
---|
| |
---|
colour | RedGreen |
---|
title | OPEN | CLOSED |
---|
|
| 07b7105f20776a1b6f4e27351365759551337431 | Changes parameter type to "ForceArray". |
MATCH 6.14.9 Office-3902 | Damjan Jovanovic | Status |
---|
| |
---|
colour | RedGreen |
---|
title | OPEN | CLOSED |
---|
|
| 07b7105f20776a1b6f4e27351365759551337431 | Changes parameter type to "ForceArray Reference|Array". |
RECEIVED 6.12.43 Office-3916 | Damjan Jovanovic | | e172229456487b113132e6d03d331cba42792c7f | A new constraint, Settlement < Maturity, had to be implemented on our RECEIVED function. |
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 | Damjan Jovanovic | Status |
---|
| |
---|
colour | RedGreen |
---|
title | OPEN | CLOSED |
---|
|
| 07b7105f20776a1b6f4e27351365759551337431 | Changes parameter type to "ForceArray Reference|Array". |
WEEKDAY 6.10.20 Office-3908 | Damjan Jovanovic | | b19cfbb97e8a126fb5034f0ea11b69365cb8e0ae | Added support for weekday types 11-17. |