[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 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.