Re: i20496 : Enhanced formula input

Hi Eike,
   Sorry for not changing the subject line  I
generally do.

Oh, when I said ++number should be converted to =++number i
meant only when
there is a formula involved (like ++number+number should be
changed to
=++number+number instead of =+number+number)

And to clarify:
When I said
1. "+func(" should also cause a formula input
(exception for +<number>).
I meant the formula input mode (arrows) should be
activated.

Really Eike, Please try the patch - there are many things
which the patch
takes care but we are still discussing.

And since many users don't know ' (quote) character  for
inputting
formula-strings - I am seriously thinking of adding an
option to enable or
disable this enhanced formula input feature. What do you
feel?


Thanks and Regards,
Muthu Subramanian

---------- Forwarded message ----------
From: Eike Rathke <erlsun.com>
To: devsc.openoffice.org
Date: Thu, 9 Aug 2007 20:50:51 +0200
Subject: Re: [sc-dev] i20496 : Enhanced formula input
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