Hi all,
sorry for another post.
Eike Rathke wrote:
...
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.
What is the purpose of '--1' => '=--1'
--1 is really +1, so, IF someone is concerned with typing fast a
formula, it defies my logic to enter '--1' instead of '1'.
IF I do use somewhere '--1', than that is because I need the '--'
preserved, and therefore I need it as a string. [converting to '=--1'
would preserve the '--', BUT I question the applicability of a formula
in this instance.]
I have serious reserves in converting '--1' and '++1' into formulas.
Maybe there should be an additional option where one can turn this on
(beside an option to turn the formula thing completely off), but I am
yet to convince that this is useful. [Or at least don't convert to
formula IF the cell type is set to text!]
I also fear, that when units (and strong typing) will be implemented in
spreadsheets (a thing I predict from the research going in the field
will come rather sooner than later), such automatic formula conversions
will make life very hard.
Sincerely,
Leonard
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
