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 <[EMAIL PROTECTED]>
To: [email protected]
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
