Re: [office-formula] row-wise order of evaluation (was:[office-formula] Groups - OpenDocument Formula Specification 2008-10-10(ODT) (OpenDocument-formula-20081010.odt) uploaded)

[Andreas J Guelzow <aguelzow@math.concordia.ab.ca>]

On Mon, 2008-10-13 at 12:16 +0200, Eike Rathke wrote:
> Hi Andreas,
> 
> On Friday, 2008-10-10 15:55:41 -0600, Andreas J. Guelzow wrote:
> 
> > > NPV: order of evaluation matters.
> > 
> > Could you elaborate on "Because the result is affected by the order of
> > values, applications shall evaluate arguments in the order given and
> > range reference and array arguments row-wise starting from top left."
> 
> The term  (values[i] / (1+Rate)^i)  delivers a position-dependent
> result.

I understand (and understood) that. I do not understand why this
requires that the _arguments_be_evaluated_in_the_order_given (versus
just that the function acts on the given sequence of arguments.  But
perhaps you mean something different with that than the usage of the
expression "evaluate arguments" in the normal context of programming.

Andreas
> 

-- 
"Liberty consists less in acting according to
one's own pleasure, than in not being subject 
to the will and pleasure of other people. It 
consists also in our not subjecting the wills 
of other people to our own."  Rousseau


Prof. Dr. Andreas J. Guelzow
Dept. of Mathematical & Computing Sciences
Concordia University College of Alberta