← Prev in month ← Prev in thread
Next in thread → Next in month →

ODFF: PMT PayType parameter should be Logical, and Nper constraint?

From
Eike Rathke <>
Date
2016-07-04T17:17:45+00:00
ID
Thread
ODFF: PMT PayType parameter should be Logical, and Nper constraint?
Hi,

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

-- 
LibreOffice Calc developer. Number formatter stricken i18n transpositionizer.
GPG key "ID" 0x65632D3A - 2265 D7F3 A7B0 95CC 3918  630B 6A6C D5B7 6563 2D3A
Better use 64-bit 0x6A6CD5B765632D3A here is why: https://evil32.com/
Care about Free Software, support the FSFE https://fsfe.org/support/?erack
← Prev in month ← Prev in thread
Next in thread → Next in month →