[OASIS Issue Tracker] (OFFICE-3910) ODFF: IPMT Type parameter should be Logical

[OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>]

    [ https://issues.oasis-open.org/browse/OFFICE-3910?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=68046#comment-68046 ] 

Regina Henschel commented on OFFICE-3910:
-----------------------------------------

In OOXML the parameter is number 0 or 1. That is described in the user reference [1] and in the specification [2].
[1] https://support.office.com/en-us/article/IPMT-function-5cce0ad6-8402-4a41-8d29-61a0b054cb6f
[2]  ISO/IEC 29500-1:2016(E) Fourth edition 2016-11-01. Section 18.17.7.172 IPMT. Page 2255

I have looked at functions NPER, PMT, PPMT, FV and RATE too. All of them have number 0 or 1 in user reference and in specification.
You get a quick access to the user reference with the alphabetic index [3]. For the specification use the index starting in 18.17.7 "Predefined Definitions" on the left side of the Acrobat Reader.

[3] https://support.office.com/en-us/article/Excel-functions-alphabetical-b3944572-255d-4efb-bb96-c6d90033e188?ui=en-US&rs=en-US&ad=US

So for xlsx-format it is number. Someone with an Excel version, that can export to ODF 1.2 should test, whether Excel uses numbers there too.

If Excel uses numbers in exports to ODF 1.2, I suggest to close the corresponding issues. 

> ODFF: IPMT Type parameter should be Logical
> -------------------------------------------
>
>                 Key: OFFICE-3910
>                 URL: https://issues.oasis-open.org/browse/OFFICE-3910
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula, Part 2 (Formulas)
>            Reporter: Patrick Durusau
>            Assignee: Patrick Durusau
>             Fix For: ODF 1.3
>
>
> 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.
> "



--
This message was sent by Atlassian JIRA
(v6.2.2#6258)