[Libreoffice-bugs] [Bug 125603] combina(n, r) function should work even when r>n

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=125603

Winfried Donkers <winfrieddonkers at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |NOTABUG
             Status|UNCONFIRMED                 |RESOLVED

--- Comment #6 from Winfried Donkers <winfrieddonkers at libreoffice.org> ---
(In reply to Julien Nabet from comment #4)
> I'm not sure here since:
> -
> https://help.libreoffice.org/6.3/en-US/text/scalc/01/04060106.
> html?DbPAR=CALC#bm_id3150284 (for LO)
> -
> https://support.office.com/en-us/article/combina-function-efb49eaa-4f4c-4cd2-
> 8179-0ddfcf9d035d?ui=en-US&rs=en-US&ad=US (for Excel)
> indicate the first number must greater or equal to the second number.
> 
> Winfried: any thoughts here?

COMBINA is a function defined in ODFF1.2:
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1018494_715980110
,
which uses o.a. the constraint that in COMBINA(N, M) N>=M.
So, COMBINA(2,3) should return an error, which it does.

So I close the bug report as the behaviour is compliant with the ODFF1.2
standard.

(I know that Excel returns 4 for COMBINA(2,3) _and_ that Excel's help states
that the first argument must be greater than or equal to the second argument.
Don't expect me to explain that.)

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190611/0bcbdf44/attachment-0001.html>