https://bugs.documentfoundation.org/show_bug.cgi?id=150019
Bug ID: 150019
Summary: ACCRINT result is wrong when basis is 1
Product: LibreOffice
Version: 3.3 all versions
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When the Basis parameter is 1, the result from ACCRINT does not match the
formula. If the same ACCRINT values are used in Excel, the result DOES match
the formula. I conclude ACCRINT is not functioning properly.
Steps to Reproduce:
Enter the following formula:
=ACCRINT("2001-2-28","2001-08-31","2001-05-01",10%,1500,2,1)
Actual Results:
25.479452
Expected Results:
25.271739
This results from the following formula in your documentation:
Rate * (Par/Frequency) * (DaysOfInterestEarned/DaysInPaymentPeriod)
Rate = .10
Par = 1500
Frequency = 2
DaysOfInterestEarned = 62 (Settlement - Issue)
DaysInPaymentPeriod = 184 (FirstInterest - Issue)
ACCRINT = .10 * (1500/2) * (62/184)
ACCRINT = 25.271739
Reproducible: Always
User Profile Reset: No
Additional Info:
I believe this is not a new bug, I am sure it existed in early 7.x releases and
possibly all Libre Calc releases. But, my help/about information is:
Version for testing 7.3.4.2 (x64)
Build: 728fec
--
You are receiving this mail because:
You are the assignee for the bug.
