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 | Status |
---|
| |
---|
colour | RedGreen |
---|
title | OPEN | CLOSED |
---|
|
|
| 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 |
| |
|
|
DCOUNT 6.9.3 Office-3906 |
| |
|
|
DCOUNTA 6.9.4 Office-3906 |
| |
|
|
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 |
| |
|
|
HLOOKUP 6.14.5 Office-3902 |
| |
|
|
IF 6.15.4 Office-3844 |
| |
|
|
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 | 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 |
| |
|
|
WEEKDAY 6.10.20 Office-3908 | Damjan Jovanovic | | b19cfbb97e8a126fb5034f0ea11b69365cb8e0ae | Added support for weekday types 11-17. |