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-1075) Public Comment: Re:[office-comment] ODFF: NPV



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

Eike Rathke commented on OFFICE-1075:
-------------------------------------

NPV already states row-wise evaluation.

XNPV:
Parameter Values is not a NumberSequence, but Array instead. Any non-numeric element makes the function return an error.
Parameter Dates is not a DateSequence, but Array instead. Any non-numeric (not date serial number) element makes the function return an error.
First element of Dates indicates the start of cash flow (already defined), all subsequent dates must be greater or equal than that (but not necessarily in order).

SERIESSUM:
Evaluation order does not matter.
Parameter Coefficients is not a NumberSequence, but Array instead. Any non-numeric element makes the function return an error.


> Public Comment: Re: [office-comment] ODFF: NPV
> ----------------------------------------------
>
>                 Key: OFFICE-1075
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-1075
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula
>    Affects Versions: ODF 1.2
>            Reporter: Robert Weir 
>            Assignee: Eike Rathke
>            Priority: Minor
>             Fix For: ODF 1.2
>
>
> Copied from office-comment list
> Original author: "David King" <openoffice@drking.plus.com> 
> Original date: 14 Aug 2008 18:12:53 -0000
> Original URL: http://lists.oasis-open.org/archives/office-comment/200808/msg00045.html

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