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] Commented: (OFFICE-2032) 6.11.37 PPMT - Testcase includes too many arguments, function definition missing



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

Eric Patterson commented on OFFICE-2032:
----------------------------------------

This test case is an example of using the last argument (Type).  The function description seems to adequately cover this argument definition.

> 6.11.37 PPMT - Test case includes too many arguments, function definition missing
> ---------------------------------------------------------------------------------
>
>                 Key: OFFICE-2032
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-2032
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula
>    Affects Versions: ODF 1.2
>            Reporter: Eric Patterson
>            Assignee: Eric Patterson
>             Fix For: ODF 1.2
>
>
> The third expression for the PPMT function appears to be incorrect, containing too many parameters.
> Current Expression:
> =PPMT(3%;1;12;100;1;200;1)
> Result:
> -23.435558876±ε
> I believe the corrected expression should be:
> =PPMT(3%;1;12;100;200;1)
> It's unclear if this affects the text of the function definition until a formula definition is added.

-- 
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]