Bug 107566 - YIELDMAT function constraint issue date < settlement date
Summary: YIELDMAT function constraint issue date < settlement date
Status: RESOLVED FIXED
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: target:5.4.0
Keywords:
Depends on:
Blocks:
 
Reported: 2017-05-02 15:45 UTC by raal
Modified: 2017-06-09 11:05 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
document used for testing. (31.02 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-05-03 14:19 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 2017-05-02 15:45:22 UTC 
Description:
Bug found during test creation

> The difference in row 1 is about the constraint issue date < settlement
> date). As the constraint is a real one (in reality it applies) and Excel
> applies this constraint, I want to change Calc to apply the constraint
> as well. 

Actual Results:  
.

Expected Results:
.


Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:53.0) Gecko/20100101 Firefox/53.0
Comment 1 Winfried Donkers 2017-05-03 14:19:07 UTC 
Created attachment 133030 [details]
document used for testing.
Comment 2 Commit Notification 2017-05-04 21:59:52 UTC 
Winfried Donkers committed a patch related to this issue.
It has been pushed to "master":

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

tdf#107566 adjust constraints for Add-In function YIELDMAT.

It will be available in 5.4.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.
Comment 3 Xisco Faulí 2017-06-09 09:54:40 UTC 
Hello,
Is this bug fixed?
If so, could you please close it as RESOLVED FIXED?
Comment 4 Winfried Donkers 2017-06-09 11:05:56 UTC 
(In reply to Xisco Faulí from comment #3)
> Hello,
> Is this bug fixed?
> If so, could you please close it as RESOLVED FIXED?

Sorry Xisco, I forgot.