[Libreoffice-bugs] [Bug 100721] PPMT function, Type parameter; Constraints: Rate and Present

[bugzilla-daemon]

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

Eike Rathke  changed:

   What|Removed |Added

 Status|UNCONFIRMED |RESOLVED
 Resolution|--- |NOTOURBUG

--- Comment #2 from Eike Rathke  ---
Also in Gnumeric, though it produces slightly different results.
Type again should be Logical Type = FALSE().
No idea about the context of Rate and Present. Note that the constraint reads
*should* be greater than 0, which is not a normative *shall* in the sense of
must. See also
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1017852_715980110

https://lists.oasis-open.org/archives/office-comment/201607/msg3.html

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100721] PPMT function, Type parameter; Constraints: Rate and Present

[bugzilla-daemon]

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

Joel Madero  changed:

   What|Removed |Added

 CC||jmadero@gmail.com

--- Comment #1 from Joel Madero  ---
> =PPMT(0.0875/12,1,36,5000,8000,3)  should be error-> Type: optional, 0 or 1
> =PPMT(0.0875/12,1,36,-5000,8000,1)  should be error->  Constraints: Rate and
> Present should be greater than 0.
> =PPMT(-0.005,1,36,5000,8000,1)should be error->  Constraints: Rate and
> Present should be greater than 0.

Each of these formulas work in Office 2013. Maybe the definition is just wrong.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs