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

[Eike Rathke <erack@sun.com>]

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
http://tools.oasis-open.org/issues/browse/OFFICE-1075
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.

Thanks
  Eike

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

PGP signature