=RECEIVED(DATE(1999,5,15),DATE(1999,2,15),1000,0.0575,0) returns value in Calc,but error in excel and gnumeric. ODFF spec was changed, see https://lists.oasis-open.org/archives/office-comment/201607/msg00008.html https://lists.oasis-open.org/archives/office-comment/201607/msg00009.html LO need to be changed too.
Fixed with https://gerrit.libreoffice.org/27619
(In reply to raal from comment #0) > ODFF spec was changed, see Nitpick: the spec wasn't changed, that's a proposal to change it.
Zdeněk Crhonek committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=ca0b7ae19a06cc575c63c64d64fb59dfa91f44be update RECEIVED test case (add test for bug tdf#101228) 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.