function ACCRINT as defined in ODF: 6.12.2ACCRINT Summary: Calculates the accrued interest for securities with periodic interest payments. Syntax: ACCRINT( DateParam issue ; DateParam first ; DateParam settlement ; Number coupon ; Number par ; Integer frequency [ ; Basis basis = 0 [ ; Logical calc_method = TRUE() ] ] ) Function has 8 parameters =ACCRINT(J1;J2;J3;J4;J5;J6;J7) works =ACCRINT(J1;J2;J3;J4;J5;J6;J7;1) Error504 =ACCRINT(J1;J2;J3;J4;J5;J6;J7;TRUE()) Error504 The last parameter is not recognized. Also not compatible with excel.
Confirmed. Arch Linux 64-bit, KDE Plasma 5 Version: 5.3.0.0.alpha0+ Build ID: c13f60e7cd18df6b0ab70289f5b91ee01e4ae126 CPU Threads: 8; OS Version: Linux 4.6; UI Render: default; Locale: fi-FI (fi_FI.UTF-8) Built on June 18th 2016
Both Excel 2013 and Gnumeric both only accept 7 arguments. This issue is discussed here: https://issues.oasis-open.org/browse/OFFICE-2566
The ACCRINT function is Calc is an Add-In function and therefore is supposed to follow the pre-Excel2003 behaviour. The ACCRINT function as defined in ODFF1.2 is not (yet) available in Calc. That is why the 8th argument is not accepted.
Dear developer, This bug has been in ASSIGNED status for more than 3 months without any activity. Resetting it to NEW. Please assigned it back to yourself if you're still working on this.
I see no easy way (yet) to make Addin functions work as OOXML-function and vice versa.
Changing importance to enhancement as this isn't implemented yet.