=AMORLINC(10000;DATE(2012;3;1);DATE(2012;12;31);1500;1;0,3;2)) result is
According to help and ODF specification basis 2 should work.
note: in excel basis 2 not exist:
Confirmed with =AMORLINC(10000;DATE(2012;3;1);DATE(2012;12;31);1500;1;0,3;2)
Removed the extra parenthesis.
Arch Linux 64-bit, KDE Plasma 5
Build ID: ff25ea3d5ccf3a990767cbb1ef99037d3f84b072
CPU Threads: 8; OS Version: Linux 4.6; UI Render: default;
Locale: fi-FI (fi_FI.UTF-8)
Built on June 26th 2016
This is caused by the add-in function Yearfrac which does not fully comply with ODFF1.2
*** This bug has been marked as a duplicate of bug 100496 ***
(In reply to Winfried Donkers from comment #2)
> This is caused by the add-in function Yearfrac which does not fully comply
> with ODFF1.2
This is not entirely correct, but is further explained in bug 100496.