https://bugs.documentfoundation.org/show_bug.cgi?id=100559
Bug ID: 100559
Summary: CUMPRINC function, type parameter
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
ODF specification: 6.12.12 CUMPRINC
Summary: Calculates a cumulative principal payment.
Syntax: CUMPRINC( Number rate ; Number periods ; Number value ; Integer start ;
Integer end ; Integer type )
Returns: Currency
Constraints: type is one of the following values: 0, 1
=CUMPRINC(0,055/12;24;5000;4;6;-1)
=CUMPRINC(0,055/12;24;5000;4;6;)
should return error. Last parameter is mandatory and allowed 0 or 1.
Checked in excel and excel return in both cases error.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
