[OASIS Issue Tracker] Commented: (OFFICE-2031) 6.11.23 PMT

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

    [ http://tools.oasis-open.org/issues/browse/OFFICE-2031?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18861#action_18861 ] 

Andreas Guelzow  commented on OFFICE-2031:
------------------------------------------

I don't thin kwe should say  "Note that this formula can be numerically unstable at very low interest rates."  There is nothing wrong with that formula. As we have indicated in general elsewhere, all these formulas give mathematical exact definitions only, not numerical methods.

If we want to include warnings of this kind here, we have to include them everywhere were forulas may be numerically unstable.

> 6.11.23 PMT
> -----------
>
>                 Key: OFFICE-2031
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-2031
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula
>    Affects Versions: ODF 1.2
>            Reporter: Eric Patterson
>            Assignee: Robert Weir 
>            Priority: Minor
>             Fix For: ODF 1.2 Part 2 CD 3
>
>
> The third test case for the IPMT Function appears to have an incorrect result specified.
> Expression:
> =IPMT(5%/12;10;360;100000)+IPMT(5%/12;10;360;100000)-PMT(5%/12;360;100000)
> Result:
> 0
> Also, it contains the note: "The total payment is the principle plus the interest.", but that is not included in the normative text.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira