=ODDLPRICE(DATE(1999,2,7),DATE(1999,6,15),DATE(1998,10,15), 0.0375, 0.0405,0,2,0) =ODDLPRICE(DATE(1999,2,7),DATE(1999,6,15),DATE(1998,10,15), 0.0375, 0.0405,,2,0) returns 1.3 in Calc, but #error in gnumeric and excel
Version: 5.3.0.0.alpha0+ Build ID: 28a03248b1d1649e157b788e43dfe8326f165379 CPU Threads: 2; OS Version: Linux 3.16; UI Render: default; Locale: en-US (en_US.UTF-8) Confirmed - have not verified that excel or gnumeric behave differently, nor have I dug into what this formula should return. Just trusting Raal's judgment and confirmation that Excel/Gnumeric result in different (and correct) values. As far as prioritizing - I suggest QA decide what the right prioritization is when we have a single formula that isn't working as expected. For now: Normal - can prevent high quality work; Medium - default I think there's a strong case to make them low if we only know of a single test case not working. Then again, may signal a wider problem.....
Same cause as bug 100729: improper use of the constraints defined in ODFF1.2.
Didn't notice that bug ID in commit summary lacked a # hence no notification here.. pushed to master as https://gerrit.libreoffice.org/gitweb?p=core.git;a=commitdiff;h=0759f31172253d6c5be3b938446ff1b8313adebd
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=b43eece4680d149985382c8528119577ab3d7c2b redemption argument must be >0 now, tdf#100766 follow-up 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.