Hi Cor, On Thursday, 2008-08-07 13:00:46 +0200, Cor Nouws wrote:
> Clear that an operator treats text numbers different than a function. Actually that's not a difference between operators and functions, but a difference between operators or functions expecting a scalar value as argument, such as the result of a single cell reference, and a cell or range reference that results in a number sequence. To illustrate Excel behavior: A1: '-3 A2: 4 =ABS(A1) => 3 =SUM(A1:A2) => 4 =SUM(A1,A2) => 4 =A1+A2 => 1 Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks.
pgpUO2sRuzVQ1.pgp
Description: PGP signature
