<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:winfrieddonkers@libreoffice.org" title="Winfried Donkers <winfrieddonkers@libreoffice.org>"> <span class="fn">Winfried Donkers</span></a>
</span> changed
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - combina(n,r) function should work even when r>n"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=125603">bug 125603</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>---
</td>
<td>NOTABUG
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>UNCONFIRMED
</td>
<td>RESOLVED
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - combina(n,r) function should work even when r>n"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=125603#c6">Comment # 6</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - combina(n,r) function should work even when r>n"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=125603">bug 125603</a>
from <span class="vcard"><a class="email" href="mailto:winfrieddonkers@libreoffice.org" title="Winfried Donkers <winfrieddonkers@libreoffice.org>"> <span class="fn">Winfried Donkers</span></a>
</span></b>
<pre>(In reply to Julien Nabet from <a href="show_bug.cgi?id=125603#c4">comment #4</a>)
<span class="quote">> I'm not sure here since:
> -
> <a href="https://help.libreoffice.org/6.3/en-US/text/scalc/01/04060106">https://help.libreoffice.org/6.3/en-US/text/scalc/01/04060106</a>.
> html?DbPAR=CALC#bm_id3150284 (for LO)
> -
> <a href="https://support.office.com/en-us/article/combina-function-efb49eaa-4f4c-4cd2">https://support.office.com/en-us/article/combina-function-efb49eaa-4f4c-4cd2</a>-
> 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?</span >
COMBINA is a function defined in ODFF1.2:
<a href="http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1018494_715980110">http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1018494_715980110</a>
,
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.)</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>