Bug 100559 - CUMPRINC function, type parameter
Summary: CUMPRINC function, type parameter
Status: RESOLVED DUPLICATE of bug 100646
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Winfried Donkers
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-06-23 08:25 UTC by raal
Modified: 2016-07-05 15:09 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
extra use cases for CUMPRINC unit test (3.31 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-07-01 10:04 UTC, Winfried Donkers 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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 ***