-
Type: Bug
-
Status: Closed
-
Priority: Major
-
Resolution: Unresolved
-
Affects Version/s: None
-
Fix Version/s: ODF 1.3
-
Component/s: OpenFormula, Part 4 (Formula) [1.2: 2]
-
Labels:None
-
Proposal:
6.12.36 PMT
[ ; Number PayType = 0 ]
should be
[ ; Logical PayType = FALSE() ]
instead, and
"
PayType: the type of payment, defaults to 0. It is 0 if payments are due
at the end of the period; 1 if they are due at the beginning of
the period. With PayType=1 the first payment is made on the
same day the loan is taken out.
"
should be
"
PayType: the type of payment, defaults to FALSE(). It is FALSE() if
payments are due at the end of the period; TRUE() if they are
due at the beginning of the period. With PayType=TRUE() the
first payment is made on the same day the loan is taken out.
"
Furthermore, LibreOffice, Excel and Gnumeric treat the Nper parameter
with constraint Nper != 0 instead of Nper > 0. If and how much sense it
makes to have Nper < 0 is beyond my financial background..
Eike Rathke https://lists.oasis-open.org/archives/office-comment/201607/msg00002.html