Hi Muthu, btw, this would be sorted into the corresponding thread if you replied on the original mail instead of some digest.. anyway.
On Thursday, 2007-08-09 13:55:13 +0530, Muthu Subramanian wrote:
> Have you tried the patch that I have attached (in issue 20496)?
No, that issue went out of my sight until recently when it came to life
again.
> It would (really) be easier if we can comment on the changes required on
> the patch (I think).
I think we should first clarify the behavior we really want. Otherwise
talking about necessary changes to the patch is moot.
> 1. "+func(" should also cause a formula input (exception for +<number>).
If so, then any formula should be evaluated, not just +<number> or
+func( Doing so would evaluate +<string> input as a formula and lookup
whether <string> happens to match a defined name, and result in #NAME?
if it doesn't. Which is what Excel does.
> 2. And w.r.t to the ++ -> =++ its for the similarity with excel (and also +
> -> =+).
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.
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.
pgp7Sc6j7BXWd.pgp
Description: PGP signature
