<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:jbfaure@libreoffice.org" title="Jean-Baptiste Faure <jbfaure@libreoffice.org>"> <span class="fn">Jean-Baptiste Faure</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - NPER function not working as anticipated following example in excel (which works in google sheets)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=112177">bug 112177</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;">Keywords</td>
<td>
</td>
<td>regression
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>UNCONFIRMED
</td>
<td>NEW
</td>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>jbfaure@libreoffice.org
</td>
</tr>
<tr>
<td style="text-align:right;">Ever confirmed</td>
<td>
</td>
<td>1
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - NPER function not working as anticipated following example in excel (which works in google sheets)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=112177#c1">Comment # 1</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - NPER function not working as anticipated following example in excel (which works in google sheets)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=112177">bug 112177</a>
from <span class="vcard"><a class="email" href="mailto:jbfaure@libreoffice.org" title="Jean-Baptiste Faure <jbfaure@libreoffice.org>"> <span class="fn">Jean-Baptiste Faure</span></a>
</span></b>
<pre>Thank you for the bug report.
Reproducible with LO 5.4.1 and current master. The problem is that this
function, in these LO versions, does not accept zero as second argument. Using
a very small value instead of 0 gives a result close to the expected value.
Works as expected in LO 5.3.6, so regression.
Best regards. JBF</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>