https://bugs.documentfoundation.org/show_bug.cgi?id=100450
Bug ID: 100450
Summary: ACCRINT 8. parameter not recognized
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
