Hi Leonard,

On Thursday, 2007-08-09 20:51:26 +0300, Leonard Mada wrote:

> >Excel converts +<number>+<number> to =<number>+<number> and ++<number>
> >to =+<number>, but converts +<name> to =+<name>
> >
> >Note that Excel does not convert single numbers like +1 or -1 but does
> >convert ++1 to =+1, --1 to =--1, +-1 to =+-1 and -+1 to =-1 (all without
> >any other trailing operators) which I find pretty disturbing.
> 
> What is the purpose of  '--1'  =>  '=--1'

I don't know. As I wrote, I don't like the attempt to handle anything
that does not involve at least two non-operator tokens (in the sense of
numbers, names, ...) as formulas. I brought these Excel examples into
play because Muthu argued that ++<number> should be converted to
=++<number> because that would be what Excel did, which it doesn't. My
examples are all cases where we should not follow Excel.

  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 this [EMAIL PROTECTED] account, which I use 
for
 mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] 
Thanks.

Attachment: pgpdFiLnWIUNf.pgp
Description: PGP signature

Reply via email to