Bug 100450 - Add ODFF1.2 ACCRINT function to Calc
Summary: Add ODFF1.2 ACCRINT function to Calc
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Function
  Show dependency treegraph
 
Reported: 2016-06-17 10:05 UTC by raal
Modified: 2019-08-12 18:40 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description raal 2016-06-17 10:05:35 UTC
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.
Comment 1 Buovjaga 2016-06-18 19:41:54 UTC
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
Comment 2 Luke 2016-09-11 19:53:13 UTC
Both Excel 2013 and Gnumeric both only accept 7 arguments. This issue is discussed here:

https://issues.oasis-open.org/browse/OFFICE-2566
Comment 3 Winfried Donkers (retired) 2016-09-22 14:40:29 UTC
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.
Comment 4 Xisco Faulí 2017-09-11 08:55:54 UTC Comment hidden (obsolete)
Comment 5 Winfried Donkers (retired) 2018-01-22 07:08:32 UTC
I see no easy way (yet) to make Addin functions work as OOXML-function and vice versa.
Comment 6 Thomas Lendo 2019-08-12 18:40:39 UTC
Changing importance to enhancement as this isn't implemented yet.