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

Olivier Hallot <[email protected]> changed:

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

--- Comment #1 from Olivier Hallot <[email protected]> ---
Some remarks

- The LibreOffice NPER function with negative payments (-153.75) returns an
error, which then invalidates the suggestion in C#0

- The ODF standard does not require a negative payment (outflow) value [1].

- The ODF standard returns a negative NPER (on the simplest example; rate=0).

- Changes in the current NPER implementation will disrupt interoperability with
other suites and break legacy documents.

- User must be aware of a negative result and act accordingly.

[1]
https://docs.oasis-open.org/office/OpenDocument/v1.4/os/part4-formula/OpenDocument-v1.4-os-part4-formula.html#__RefHeading__1018288_715980110

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to