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


Help: OASIS Mailing Lists Help | MarkMail Help

office-formula message

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

Subject: Re: [office-formula] office-2227: Proposed Resolution

Hi Eric,

On Saturday, 2010-01-16 00:02:25 +0000, Eric Patterson wrote:

> Attached is the proposed updated to the XNPV function for Office-2227.

Thanks. Please see also
for additional changes. I added that to the Proposal field.

It isn't quite clear to me what the wording "optional" in

| The first cash-flow amount is optional and corresponds to a cost or
| payment that occurs at the beginning of the investment, represented by
| a negative number.

would imply. To my understanding the first amount can't be optional but
must be present, it is an element of an Array (note: not NumberSequence,
see OFFICE-1075) argument. It think optional here means that the value
does not necessarily have to be negative. If yes, shouldn't that be
worded different?

Btw, for mathematical formulas please use a math formula object instead
of an image, and in the formula use variable names corresponding to the
parameter names.


Automatic string conversions considered dangerous. They are the GOTO statements
of spreadsheets.  --Robert Weir on the OpenDocument formula subcommittee's list.

PGP signature

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