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.
pgpdFiLnWIUNf.pgp
Description: PGP signature