Bug 100559

Summary:	CUMPRINC function, type parameter
Product:	LibreOffice	Reporter:	raal <raal>
Component:	Calc	Assignee:	Winfried Donkers <winfrieddonkers>
Status:	RESOLVED DUPLICATE
Severity:	normal
Priority:	medium
Version:	unspecified
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	extra use cases for CUMPRINC unit test

Description raal 2016-06-23 08:25:23 UTC

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.

Comment 1 Winfried Donkers 2016-07-01 10:04:31 UTC

Created attachment 126021 [details]
extra use cases for CUMPRINC unit test

(Document created by Excel Online.)

Comment 2 Winfried Donkers 2016-07-05 15:09:05 UTC


*** This bug has been marked as a duplicate of bug 100646 ***