OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

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

     [ http://tools.oasis-open.org/issues/browse/OFFICE-2031?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Robert Weir  updated OFFICE-2031:

As Eric noted, the function should return -287.35 for that test case.  However, we're stripping out test cases, so that change is note needed

However, we do need to change the line "Note that the formula may be numerically unstable at very low rates."  This is good English, but bad ISO.  "May" should be used exclusively "to indicate a course of action permissible within the limits of the document." We are not giving permission to be numerically unstable, but just noting that it is possible.  In that case, the proper ISO term to use is "can", which is used for " statements of possibility and capability, whether material, physical or causal."  So we should say,  "Note that this formula can be numerically unstable at very low interest rates."

  was:As written, I believe that the function should return -287.35.  It appears that the intent of the test case was to show how IPMT and PMT are related.  There is nothing in the text of the function that describes this.  If this is critical to the function, it should be added to the text.

> 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


[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]