Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Update the CELL function

...

TopicDeveloperStatusBZ ID / Git commitComment

BESSELI 6.16.12 Office-3842

Damjan Jovanovic 

Status
colourGreen
titleCLOSED


Changes the type of first argument from Integer to Number. We already use Number.

BESSELJ 6.16.13 Office-3842

Damjan Jovanovic 

Status
colourGreen
titleCLOSED


Changes the type of first argument from Integer to Number. We already use Number.

BESSELK 6.16.14 Office-3842

Damjan Jovanovic 

Status
colourGreen
titleCLOSED


Changes the type of first argument from Integer to Number. We already use Number.

BESSELY 6.16.15 Office-3842

Damjan Jovanovic 

Status
colourGreen
titleCLOSED


Changes the type of first argument from Integer to Number. We already use Number.

CELL 6.13.3 Office-3909

Damjan Jovanovic 

Status
OPEN
colourRedGreen
titleCLOSED


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 

Status
colourGreen
titleCLOSED


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 

Status
colourGreen
titleCLOSED


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


Status
colourRed
titleOPEN



DCOUNT 6.9.3 Office-3906


Status
colourRed
titleOPEN



DCOUNTA 6.9.4 Office-3906


Status
colourRed
titleOPEN



FLOOR 6.17.3 Office-3879

Damjan Jovanovic 

Status
colourGreen
titleCLOSED


Changes FLOOR() to round towards zero, like it should, instead of away from zero. We already do that.

FTEST 6.18.30 Office-3903


Status
colourRed
titleOPEN



HLOOKUP 6.14.5 Office-3902


Status
colourRed
titleOPEN



IF 6.15.4 Office-3844


Status
colourRed
titleOPEN



ISBLANK 6.13.14 Office-4000

Damjan Jovanovic 

Status
colourGreen
titleCLOSED

118236Updates documentation, adding "This function does not propagate Error values." We already do that.

ISFORMULA 6.13.18 Office-4000

Status
colourGreen
titleCLOSED

118236Updates documentation, adding "This function does not propagate Error values." We already do that.

ISLOGICAL 6.13.19 Office-4000

Damjan Jovanovic 

Status
colourGreen
titleCLOSED

118236Updates documentation, adding "This function does not propagate Error values." We already do that.

ISNONTEXT 6.13.21 Office-4000

Damjan Jovanovic 

Status
colourGreen
titleCLOSED

118236Updates documentation, adding "This function does not propagate Error values." We already do that.

ISNUMBER 6.13.22 Office-4000

Damjan Jovanovic 

Status
colourGreen
titleCLOSED

118236Updates documentation, adding "This function does not propagate Error values." We already do that.

ISREF 6.13.24 Office-4000

Damjan Jovanovic 

Status
colourGreen
titleCLOSED

118236Updates documentation, adding "This function does not propagate Error values." We already do that.

ISTEXT 6.13.25 Office-4000

Damjan Jovanovic 

Status
colourGreen
titleCLOSED

118236Updates documentation, adding "This function does not propagate Error values." We already do that.

LINEST 6.18.41 Office-3902, Office-3948


Status
colourRed
titleOPEN



LOGEST 6.18.42 Office-3902


Status
colourRed
titleOPEN



MATCH 6.14.9 Office-3902


Status
colourRed
titleOPEN



RECEIVED 6.12.43 Office-3916

Damjan Jovanovic 

Status
colourGreen
titleCLOSED

e172229456487b113132e6d03d331cba42792c7fA new constraint, Settlement < Maturity, had to be implemented on our RECEIVED function.

STDEVP 6.18.74 Office-3856

Damjan Jovanovic 

Status
colourGreen
titleCLOSED


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 

Status
colourGreen
titleCLOSED


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 

Status
colourGreen
titleCLOSED

118236Updates documentation, adding "This function does not propagate Error values." We already do that.

VARPA 6.18.85 Office-3856

Damjan Jovanovic 

Status
colourGreen
titleCLOSED


Adds a constraint that mandates a sample size of at least 1 element, which we already require.

VLOOKUP 6.14.12 Office-3902


Status
colourRed
titleOPEN



WEEKDAY 6.10.20 Office-3908

Damjan Jovanovic 

Status
colourGreen
titleCLOSED

b19cfbb97e8a126fb5034f0ea11b69365cb8e0aeAdded support for weekday types 11-17.

...