Bug 100523 - AMORDEGRC function, negative values
Summary: AMORDEGRC function, negative values
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Winfried Donkers
URL:
Whiteboard: target:5.3.0
Keywords:
Depends on:
Blocks:
 
Reported: 2016-06-21 16:25 UTC by raal
Modified: 2016-10-25 18:39 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
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-21 16:25:13 UTC 
=AMORDEGRC(10000;DATE(2012;3;1);DATE(2012;12;31);1500;-1;0,3;4) -> result 0
=AMORDEGRC(10000;DATE(2012;3;1);DATE(2012;12;31);-1500;1;0,3;4) -> result 2818

Both results should be #error.

Tested with excel and excel throws error.
Comment 1 Winfried Donkers 2016-06-22 06:08:43 UTC 
The results from Calc differ from those from Excel; I will investigate and see if a fix is possible.
Note: this function is an 'Excel Analysis package Add-On function'.
Comment 2 Commit Notification 2016-06-28 14:50:22 UTC 
Winfried Donkers committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=e227b6516295c6954d24a8eb67d2f0c0475c32e9

tdf#100523 Add constraints for AMORDEGRC function.

It will be available in 5.3.0.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.