
Type: Bug

Status: Closed

Priority: Major

Resolution: Unresolved

Affects Version/s: None

Fix Version/s: ODF 1.3

Component/s: OpenFormula, Part 2 (Formulas)

Labels:None

Proposal:
6.12.29 NPER
[ ; Number PayType ]
should be
[ ; Logical PayType = FALSE() ]
which is what Excel, Gnumeric and LibreOffice do.
"
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.
"
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.
"
Also, [ Number Fv ] should mention the default value 0, so
[ Number Fv = 0 ]