
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.23 IPMT
defines the last parameter as [ ; Number Type = 0 ]
Excel, LibreOffice and Gnumeric treat it as Logical instead, the
definition should be [ ; Logical Type = FALSE() ]
and
"
Type: the due date for the payments (optional). Zero if omitted. If type
is 1, then payments are made at the beginning of each period. If
type is 0, then payments are made at the end of each period.
"
be changed to
"
Type: the due date for the payments (optional). FALSE() if omitted. If
type is TRUE(), then payments are made at the beginning of each
period. If type is FALSE(), then payments are made at the end of
each period.
"