[Libreoffice-bugs] [Bug 112177] NPER function not working as anticipated following example in excel ( which works in google sheets)

[bugzilla-daemon at bugs.documentfoundation.org]

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

Jean-Baptiste Faure <jbfaure at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Keywords|                            |regression
             Status|UNCONFIRMED                 |NEW
                 CC|                            |jbfaure at libreoffice.org
     Ever confirmed|0                           |1

--- Comment #1 from Jean-Baptiste Faure <jbfaure at libreoffice.org> ---
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

-- 
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/20170902/7ee98864/attachment-0001.html>