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] ABS != Abs?


Hi Dennis,

On Monday, 2010-02-08 10:23:29 -0800, Dennis E. Hamilton wrote:

> Right, the first note (in 2.3(1.1)) fails to take the Absolute value and
> incorrectly delivers a negative number.  The result should be "3", not "-3".

Wrong. The examples give the element that is taken from the array in
that context, not the final result of the formula.

  Eike

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